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 split multiple columns with concatenated strings into rows in PowerQuery, we will write M code...

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

In this blog let's see how we can combine Stored Procedure and Parameters to load data into PBI. First we need to create a very basic...

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...