M | antmanbi

Oct 6, 20212 min read

Create a Date table in Power Query with M code

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

Sep 3, 20211 min read

How To Load Data In Power BI With Stored Procedure and Parameters

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

Jul 1, 20212 min read

Dynamically Remove Null Columns in Power Query with M code

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

Jun 17, 20211 min read

Dynamically change column names in Power Query using predefined values

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

May 3, 20211 min read

Clean a string using M in Power Query

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

www.antmanbi.com