Data: show as month/year format

[aurix]

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?

[lbendlin]

you can consider using Date.ToText - PowerQuery M | Microsoft Learn

[watkinnc · Accepted solution]

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