BI
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
July 24, 2021
No Comments
Blog & News
Explore the latest insights, trends, and innovations in Microsoft Fabric, Power BI, Azure, Databricks, and modern data platforms.
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
May 14, 2020
No Comments
DAX
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 more detail
April 11, 2020
No Comments
DAX
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
March 29, 2020
No Comments
Azure
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
December 6, 2019
No Comments
DAX
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’
September 20, 2019
No Comments
DAX
Year to Year Growth by Fiscal Weeks
Although calculating year to year growth simply can be done by using DAX formulas such as SamePeriodLastYear() or DateAdd(), but for some business that tracking
January 1, 2019
No Comments