Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
This code is giving date in format yyyy.mm.dd = Text.From(Date.Year(DateTime.LocalNow())-2)&"."&Text.End("0"&Text.From(Date.Month(DateTime.LocalNow())),2)&"."&Text.End("0"&Text.From(Date.Day(DateTime.LocalNow())),2)&"."
I want date in format dd.mm.yyyy so i made following changes -
Text.From("0"&Text.From(Date.Day(DateTime.LocalNow())),2)&"."&Text.End("0"&Text.From(Date.Month(DateTime.LocalNow())),2)&"."&Text.End(Date.Year(DateTime.LocalNow())-2)&"."
Now i am getting an error "we cannot convert the value 2 to type text ".
Will you please check what's wrong with my code.
Solved! Go to Solution.
Please try this instead
= Date.ToText(Date.From(DateTime.LocalNow()), "dd.MM.yyyy")
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this instead
= Date.ToText(Date.From(DateTime.LocalNow()), "dd.MM.yyyy")
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for the Reply
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.