Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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"))