Back
I have Year number and Month Number in my data. How using DAX can I get the month name out of month number?
In SSRS it is very easy. But how to achieve that using DAX?
We can use :
MonthName = FORMAT(DATE(1, [Num], 1), "MMM")
We need a simple reconstruction of a fake date from the month number provided, and reformat it with the FORMAT function.
As an alternative, we can go the old-fashioned way and write a SWITCH statement and hard-coded for the 12 months. It's up to you.
Check out the Power BI Microsoft certification course provided by Intellipaat to learn and master this tool.
31k questions
32.8k answers
501 comments
693 users