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…
Category: Power 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 skills to keep the…
Analysing Twitter and Amazon by MongoDB and Power BI
Introduction Using MongoDB you can simply import a JSON file and create a database, apply natural language processing techniques using NLTK in python and lastly visualise your sentiments using…
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…