How to change format from Month name to "MMM" format in power bi

[Deepakbqsingh]

I am trying to change the format of my Month column to "MMM" format using the DAX query FORMAT(Sales([MONTH]), "MMM").

I am getting the below error.

Right now values in my month column is in below format.

Please suggest the right way to achieve this.

Thanks.

[Sakshi_Kank_08]

MonthShortMeasure = FORMAT(SELECTEDVALUE([YourDateColumn]), "MMM") 

This one of the way to change the Month name to "MMM" format

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if you have date_column in the table, but I suggest like below.

Please check the attached pbix file.

- if you have date column in the table, try using Date.ToText function in Power Query Editor.

Date.ToText - PowerQuery M | Microsoft Learn

- if you want to use full_month_name column, try using Text.Start function in Power Query Editor.

Text.Start - PowerQuery M | Microsoft Learn