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.
Hi community,
I've a doubt regarding Date Formatting in M-Query.
I'm trying to learn and execute Date formatting in M-Query using below M-Query code:
Table.TransformColumns(Source, {{"DateColumn", each DateTime.ToText(_, "yyyy-MM-dd"), type text}})
I'm doing the transforming in Calendar Date Master Table.
I've Date and Year column and based on the Date column I'm trying to Create a Custom column named (Custom Date Format) using M-Query.
Below is the error snip:
Please help!
Solved! Go to Solution.
Hi @Niraj_vora0106 ,
How about this:
You could, however, also change the date format in Power BI:
Thereby, you wouldn't need to create a new column in Power Query.
Hope this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Hi @Niraj_vora0106 ,
How about this:
You could, however, also change the date format in Power BI:
Thereby, you wouldn't need to create a new column in Power Query.
Hope this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
@Niraj_vora0106 Try:
#"Added Custom Column" = = Table.AddColumn(#"Changed Type", "Custom Date Format", each DateTime.ToText([Date], "yyyy-MM-dd"))