Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Date Formatting in Custom Columns

Hi all!

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

amaniramahi
6 years ago
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

8 Replies

amitchandak
Super User
6 years ago
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
  Not applicable
  6 years ago
  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
    Helper V
    6 years ago
    your formula in M (Power Query)
    the formula was given to you is DAX