Power BI VertiPaq engine uses a high compression algorithm based on Columnstore structure, enabling it to load the data into the data model with significant size reduction compared to the…
Author: Ali Sharifi
Show data for the last N months based on a selected month
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…
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…
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…