Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@Miss_A
In Power Query, add a custom column,:
Date.ToText(Date.FromText( "1-" & [Column1],"en-gb"), "MM-yyyy")
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Miss_A
In Power Query, add a custom column,:
Date.ToText(Date.FromText( "1-" & [Column1],"en-gb"), "MM-yyyy")
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you. It working.