A Power BI DAX query time comparison of snowflake and star schema based on a sales reporting model done with Power BI. What Consider the relationships of the tables in Figure 1 below. The setup… Read More »The Cost of Relationships, Snowflake vs Star Schema
SUMMARIZE AND SUMMARIZECOLUMNS DAX function examples. Discussion on DAX MEASURE usage vs static alternatives. What Often there is a need to (distinct) count or sum values based on multiple filtered tables over a selected variable… Read More »Power BI DAX How to Summarize Data From Multiple Tables
Think about trying to find something from a book without looking the table of contents. This is what SQL server does as a standard with a table which does not have indexes. What In this… Read More »SQL Window Function 4 Times Faster with an Index
An example on creating a virtual table relationship with DAX TREATAS function. What Sometimes due to business logic we want to link two tables with a different key than the one already in the data… Read More »Power BI DAX How to Link Data Without a Table Relationship
An example on DAX SUMX function which is the perfect row iteration function for a lot of use cases What Often there is a need to calculate a DAX measure in a row level combining… Read More »Power BI DAX How to Calculate in Row Level with Multiple Tables