The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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