Antriksh Sharma

Today, I am going to show you how to bring/join the rows of previous partition with the current partition in DAX, with the metrics for the previous rows in the current time frame. From the above image you can see there are 2 Customers in 2021 that are brought forward into 2022 with their Sales in 2021 and Sales in 2022. First order of business is to get TOPN Customers in each year and for that we can use TOPN paired with GENERATE or with WINDOW VAR N = 2 VAR TopCustomersEveryYear = ADDCOLUMNS...

Here is how to insert blank rows after each group, sample data: OrderID OrderDate Product Category Quantity NetPrice 1001 2025-01-01 Laptop Electronics 1 60000 1002 2025-01-02 Smartphone Electronics 2 42000 1003 2025-01-03 Headphones Accessories 3 4200 1004 2025-01-04 Laptop Electronics 1 65000 1005 2025-01-05 Smartphone Electronics 1 21000 1012 2025-01-12 Headphones Accessories 4 5500 With Excel's Dynamic Array Functions: =LET( Table, Sales, u, UNIQUE(Sales[Product]), n, 1, AppendBlanks,...

In an earlier blog post I showed how to implement Fill Up and Fill Down in DAX that relied heavily on using Calculated Columns. However now that I have more experience with WINDOW functions I can show you a solution that does all of that with just measures. But first I will introduce a simpler dataset that makes it easier to consume. The table contains only 3 columns. These 3 columns together do not make up unique combination, the row (2025-02-01, null, null) is present twice at Row number 2...