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
Key date and time intelligence function examples on common use cases What Power BI DAX has a long list of different Date and Time Intelligence related functions. However, by pareto principle a couple of them… Read More »Power BI DAX How to Calculate and Filter Based on Dates
Power Query M code to create date table to cover most fiscal date related reporting needs What Most data models need a calendar table. The more the calendar table can do itself the simple and… Read More »Power BI Financial Date Table