Date Formatting in Custom Columns

[Anonymous]

Hi all!

Can anyone tell me how to format a date field using a Custom Column where the date is formatted to MMM-YYYY?

[amitchandak]

Month Year = FORMAT([Date],"mmm-yyyy")

also create a sort column and made it sort column
Month Year sort = FORMAT([Date],"yyyymm")

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

Ok, I'm getting the following error message:

Expression.Error: The name 'Format' wasn't recognized. Make sure it's spelled correctly.

And below is my custom column formula:

= Table.AddColumn(#"Changed Type1", "Month Year", each Format([dReceievedDate],"MMM-YYYY"))

[amaniramahi]

your formula in M (Power Query)

the formula was given to you is DAX

[Anonymous]

Thanks this explians everything, I'm very knew to PowerBI, where and when is Dax used?

I'm trying to create a seperate column which shows the date as MMM-YYYY, do you have any step by step instructions on how I do this if it's not done via a Custom Column?

Many Thanks

[amaniramahi]

which version do you use? is it March 2020 version?

you can find it from File>About>Version

[Anonymous]

Hi Amaniramahi,

I use the following version

Version: 2.79.5768.1082 64-bit (March 2020)

[amaniramahi · Accepted solution]

go to the table that contains the date column

select the date column

column tool tab will appear

in the format, enter mmm-yyyy "in small letters" as below image

tell me what you got, this should work

[Anonymous]

Hi Amanirmahi,

This works perfectly thank you!