How do I convert the date from 31 August 2024 to August 2024

[LT4RFF]

Hello,

Get used to seeing my name - I will be here for a while.

Issue #1

I have a data set that has a 'Reporting Period' column.

In this column the date format reads '31 August 2024'.

I would like to change this to 'August 2024' in Power Query so that when it comes to creating a dashboard in Report View I am able to create a drop down box with 'August 2024, September 2024, October 2024' etc etc.

How do I do that please?

[Omid_Motamedise]

See this formula

= Date.ToText(Date.From("31 August 2024"),"yyyy MMMM")

[v-xinruzhu-msft]

Hi,

Thanks for the solution Greg_Deckler offered, and i want to offer some more information for user to refer to.

hello @LT4RFF , you can add a new custom column to format the date.

=Date.ToText([Date], [Format="MMMM yyyy", Culture="de-DE"])

Then you can put the new column to the slicer.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@LT4RFF Is that column an actual date column or is it a text column?

[LT4RFF]

@Greg_Deckler It's an actual date column. The cells are formatted to date on the original excel spreadsheet

[Greg_Deckler · Accepted solution]

@LT4RFF So, in my opinion, you should control that in Power BI Desktop. If you select the column in Power BI Desktop ( not Power Query Editor ) then you can modify the display format in the Column tools tab of the ribbon:

[LT4RFF]

@Greg_Deckler Thank you that was the easiest way of doing it

@v-xinruzhu-msft & @Omid_Motamedise Thank you - I tried your ways first and got into all sorts of confusing issues. My skills in PBI are minimal.

I'll be back with more questions soon!