How do I convert month format in Power BI

Question

I need to create multiple reports with different sets of data. The main problem is that the data is in raw format and I need to filter it out first and then create my reports. In order to do so I need to change some formats in dates so that it can easily be sorted.

How do I do this with the help of Power BI Desktop?

Answer 1

Hi,

This can easily be done using DAX functions in Power BI

You can use this function to perform the above operation

MonthName = ‘Table Name’ [Date] . [Month]

Or,

MonthName = FORMAT (DATE (1, [NUM] , 1) , “MMM”)

Note: DAX is not a programming language, its a formula based language