Solved: Month format

Miss_A · ‎12-27-2023

I have month name, 3-2023,4-2023,5-2023, 10-2023. I wnat to change to 01-2023, 02-2023, 03-2023,10-2023 ect. how can I do it.

Fowmy · ‎12-27-2023

@Miss_A

In Power Query, add a custom column,:

Date.ToText(Date.FromText( "1-" &  [Column1],"en-gb"), "MM-yyyy")

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎12-27-2023

@Miss_A

In Power Query, add a custom column,:

Date.ToText(Date.FromText( "1-" &  [Column1],"en-gb"), "MM-yyyy")

Did I answer your question? Mark my post as a solution! and hit thumbs up

Miss_A · ‎12-27-2023

Thank you. It working.

Month format