What function can be used to extract Month Name in DAX and Power Query repectively ?

[amirabedhiafi]

What function can be used to extract Month Name in DAX and Power Query repectively ?

• MonthName,Date.MonthName
• Extract, Date.MonthName
• Format, Date.ToText
• Month,Date.ToMonth

[v-easonf-msft · Accepted solution]

Hi , @amirabedhiafi 

In PQ ,if your column type is 'Date', you can use the option  'Date'->'Month'->'Name of Month'  to create a custom column.

You can also use function 'Date.MonthName' to create a custom column as below:

=Date.MonthName([Date], "en-GB")

In Dax, if you column type is 'Date', you can create a calculated column to extract the month.

Dax_monthname3 = 'Table'[Date].[Month]

Dax_monthname4 = FORMAT('Table'[Date],"mmm")

Best regards,

Eason Fang

[parry2k]

@amirabedhiafi in DAX you will do

Month Name = FORMAT ( Table[Date], "MMM" ) //for abbreviated month name

Month Name = FORMAT( Table[Date], "MMMMM" ) //get full month name

In PQ you will do this

Date.ToText([Date Column], "MMM") //for abbreciated

Date.Text([Date Column], "MMMM" ) //for full month name

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡