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,

In this blog let's take a look at how to create cartesian product of 2 or more columns/lists in PowerQuery with UI, List Functions and Recursion when number of columns aren't fixed.

In this blog let's take a look at how to compute New and Returning Customers with Excel's Dynamic Array Functions and Power Query.

In this blog let's take a look at how to split multiple columns with concatenated strings into rows in PowerQuery, we will write M code...

In this post let's take a look at how to convert a text string such as 2h15m8s to 135.13 minutes This is the table that we are working...

I was looking for a good week based date table on Internet and found only 1-2 but I didn't find columns that I needed, so my search ended...

Having a complete date table in your SSAS model is extremely important, a complete Date table helps in ensuring that the time...

I was recently working with a dataset and found that there were a lot of columns that were completely null, now going 1 by 1 through each...

In Power Query if you want to change names of columns you can easily do so by going through each column one by one and then renaming...

In this blog I am going to show you how you can remove unwanted characters all at once from an improper text string like the following...