The internal behavior of Calculated Columns, Row Contexts and the EARLIER() Function in Power BI

Evaluation context is the heart of the DAX language in Power BI ¬†and it is essential to learn them in order to understand the internal behavior of the calculation engine in tabular data models. In this article, We will closely understand how calculated columns are created, its relationship to the row context and the EARLIER … Continue reading The internal behavior of Calculated Columns, Row Contexts and the EARLIER() Function in Power BI

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. For Example, you have a Revenue Table that records data at a day granularity and Budget table with data stored in the monthly … Continue reading Handle different granularities without creating relationships in Power BI (Logical Relationships Approach)

Golden Rules of working with Time Intelligence functions in Power BI

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 to the same period from a year ago are very important for any business intelligence tool. DAX includes more than 35 functions expressly … Continue reading Golden Rules of working with Time Intelligence functions in Power BI

How to use RANKX to calculate the Dynamic Rankings in Power Pivot and Power BI

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 scalar function and it is also an iterator. The RANKX function can optionally take a Value argument that represents a scalar value whose … Continue reading How to use RANKX to calculate the Dynamic Rankings in Power Pivot and Power BI