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
3,191 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,890 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
2,025 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,995 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,890 points
626 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,890 points
2,342 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
6,186 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,890 points
22,476 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,890 points
6,744 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
78,624 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,890 points
108,357 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