top of page
Power BI | Excel | Python | SQL
Search

Convert Hour Minute Seconds text to Minutes in Power Query
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...
Antriksh Sharma
Jun 12, 20232 min read
794
0

445, 454, or 544 Week table in Power BI and Excel
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...
Antriksh Sharma
Feb 16, 20231 min read
453
0

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...
Antriksh Sharma
Oct 6, 20212 min read
2,785
0

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...
Antriksh Sharma
Sep 3, 20211 min read
4,942
0

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...
Antriksh Sharma
Jul 1, 20212 min read
5,291
2

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...
Antriksh Sharma
Jun 17, 20211 min read
893
0

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...
Antriksh Sharma
May 3, 20211 min read
258
0
bottom of page