The demo file can be downloaded here.
Sometimes, It is required to Copy & reuse the ready made calculations in your Power BI Model without understanding the logic behind the scene. Even, Power BI Desktop June 2017 Release now […]
Handle different granularities without creating relationships in Power BI (Logical Relationships Approach)
It is really common scenario in the BI data models that you have to handle the data of the different granularities when at least two tables contain different levels of information stored. […]
IF..THEN..ELSE conditional programming logic is most common in all programming languages and it is one of the powerful weapon to handle the complex calculations. Those familiar with SQL, CASE Statements are […]
One of the most common calculations performed in data analysis is to compare some number to a comparable number for a different time period. Calculations that make comparisons to last month or […]
The DAX language in Power BI has a function RANKX that returns a ranking of a number in a list of numbers for each row in the Table argument. RANKX is a […]