DAX (Data Analysis eXpressions) introduces the functions RELATED and RELATEDTABLE for following & navigating through the chain of relationships in Power BI, Power Pivot & SSAS Tabular and It is used to retrieve related data from another table. Both of these functions are more powerful than VLOOKUP in Excel in a couple of ways. First, … Continue reading The Magic of RELATED & RELATEDTABLE functions in DAX
Traditionally, business intelligence projects tend to use a star (Kimball) or snowflake(Inmon) schema; a design approach that has become the de facto design standard for data warehouses and cubes over the last few decades. Below is an example of a star schema: The center of the star is called the fact table. It describes the … Continue reading How do relationships work in Power BI?
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 features ready to use measures that can be applied to your data model. Having a compiled list of these measures gives you the … Continue reading Top 10 Ready to Use Time Intelligence Calculations for Power BI
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)
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 the one of the way to achieve the end results. In Power BI, DAX has its own syntax and it is using SWITCH/Nested … Continue reading How to handle the SQL CASE logic in DAX
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
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