Forum Discussion

aurix's avatar
aurix
New Member
2 years ago
Solved

Data: show as month/year format

Hi all. New to Power BI.

I have three columns - day/month/year, month and year, each date type. I want to keep the day/month/year and have a second column showing month and year, but when i create the column and change the data type to date the format goes back to day/month/year. Any ideas how to fix this in Power Query M?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    If you are talking about a format of MM/YYYY, that has to be type text. 08/2024 isn't really a date, so date type won't work. You need to use

     

    Table.AddColumn(PriorStepOrTableName, "Month/Year", each Text.From(Date.Month([Date]))&"/"&Text.From(Date.Year([Date])), type text)

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    If you are talking about a format of MM/YYYY, that has to be type text. 08/2024 isn't really a date, so date type won't work. You need to use

     

    Table.AddColumn(PriorStepOrTableName, "Month/Year", each Text.From(Date.Month([Date]))&"/"&Text.From(Date.Year([Date])), type text)

     

    --Nate