Add leading 0 zero to month number in power BI

Question

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?

Answer 1

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!