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…
Tag: Power BI
Converting UTC to local datetime in Power BI
Nowadays many systems such as cloud services and IOT devices that work globally prefer to use the UTC time zone to be consistent across different countries. When it comes to…
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…