Forum Discussion
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 t...
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
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