Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
In power query, how to change the delivery month to MM/YYYY (07/2024)?
Solved! Go to Solution.
@pang22 , You can add new custom column and extract month and date.
Use below given M-Code in customcolumn
= Text.PadStart(Text.From(Date.Month([DeliveryMonth])), 2, "0") & "/" & Text.From(Date.Year([DeliveryMonth]))
Proud to be a Super User! |
|
Hi @pang22
In Power Query, the date format is decided by your computer's regional setting when the column is of date data type. If you want to display a date in MM/YYYY (07/2024) format, you will have the result of Text data type. To convert dates to text in MM/YYYY (07/2024) format, you can use Date.ToText - PowerQuery M | Microsoft Learn
Add a custom column with
Date.ToText([Delivery Month], [Format="MM/yyyy"])
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi @pang22
In Power Query, the date format is decided by your computer's regional setting when the column is of date data type. If you want to display a date in MM/YYYY (07/2024) format, you will have the result of Text data type. To convert dates to text in MM/YYYY (07/2024) format, you can use Date.ToText - PowerQuery M | Microsoft Learn
Add a custom column with
Date.ToText([Delivery Month], [Format="MM/yyyy"])
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
@pang22 , You can add new custom column and extract month and date.
Use below given M-Code in customcolumn
= Text.PadStart(Text.From(Date.Month([DeliveryMonth])), 2, "0") & "/" & Text.From(Date.Year([DeliveryMonth]))
Proud to be a Super User! |
|
Check out the July 2025 Power BI update to learn about new features.