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 8, 2020 in Power BI by anonymous
• 10,520 points
2,920 views

1 answer to this question.

0 votes

You can use the FORMAT function for this:

Expiry_MonthYear_Sorter = FORMAT([Expiry_Date], "YYYYMM")

If you wish to master Power BI Concepts, Check out Power BI Course Topics now!

answered Oct 8, 2020 by Gitika
• 65,910 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
1,748 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
• 33,030 points
6,732 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,910 points
462 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,910 points
2,145 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
5,585 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,910 points
21,715 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,910 points
6,387 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,520 points
77,004 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,910 points
104,992 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP