Power BI doesn’t have out of the box features to cover all of the UI use cases and occasionally we need to use our DAX skills to keep the…
Category: DAX
Show growth value and percentage by one Power BI Card
In most of the reports, it is a very popular requirement to show the growth value and percentage of metrics over a period of time. In Power BI, the…
Calculation Groups Use Cases - Power BI Matrix
Calculation Groups Use Cases – Power BI Matrix In my previous post here I explained Calculation Groups and how to create them in SSAS. After that I have started exploring…
Calculation Group in SSAS 2019
What is Calculation Group Calculation group is a new DAX feature introduced in SSAS 2019 where it creates generic DAX formulas in the model and uses them for different measures…
Monitoring Azure SSAS Performance by Power BI
An important part of any data source system is monitoring when the admins can check the health of the system and be aware of consumption rate. In Azure Analysis Service…
Analysing Customer Sales by RANKX() and What If Parameters
In this post I am going to show how to use a combination of RANKX() function and Power BI What-If parameters to analyse the customers’ monthly sales and find out…