Add leading 0 zero to month number in power BI

0 votes

I want a DAX formula that is concatenating a month number to a year.

If the month number is less than 10, I want to add a leading zero to it but I'm new to DAX and I can't seem to figure out how to do it?

Oct 7, 2020 in Power BI by anonymous
• 10,440 points
608 views

1 answer to this question.

0 votes

You can use the FORMAT function for this:

Expiry_MonthYear_Sorter = FORMAT([Expiry_Date], "YYYYMM")
answered Oct 7, 2020 by Gitika
• 65,870 points

Related Questions In Power BI

0 votes
1 answer

How to add roles in power BI?

1. Go to Modelling ribbon -> Manage ...READ MORE

answered Oct 30, 2019 in Power BI by ch
• 3,450 points
680 views
0 votes
1 answer

How to add image in Power BI Report?

Follow the below steps: Create a column with ...READ MORE

answered Oct 31, 2019 in Power BI by Cherukuri
• 32,930 points
5,169 views
0 votes
1 answer

How to add a One drive Excel as a Data set in Power BI?

If the one Drive is from your ...READ MORE

answered Oct 29, 2020 in Power BI by anonymous
• 65,870 points
100 views
0 votes
1 answer

How to use Dynamic DAX Number Format in power BI?

You can give them the same display ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,870 points
302 views
0 votes
1 answer
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

answered Sep 24, 2020 in Power BI by Alisha
176 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,870 points
5,028 views
0 votes
1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

answered Oct 1, 2020 in Power BI by Gitika
• 65,870 points
1,795 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,440 points
19,769 views
0 votes
3 answers

How to replace Blank with "0" in Power BI Visual?

so you are using the raw source ...READ MORE

answered Dec 15, 2020 in Power BI by Gitika
• 65,870 points
24,486 views