Antriksh Sharma
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...
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Jul 1, 2021
- 2 min
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...
2,3201
Antriksh Sharma
- Jun 17, 2021
- 1 min
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...
1180
Antriksh Sharma
- May 3, 2021
- 1 min
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...
1060