Modelling Complex Relationships in Power BI Desktop

Modern self-service BI products like Power Pivot in Excel and Power BI Desktop are often used to mash up data from different sources. Once multiple tables are imported into the model, users can create relationships among them to create a data model so that they can easily slice and dice data using any column from related tables as long as … Continue reading Modelling Complex Relationships in Power BI Desktop

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