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.
DAX does not seem to have a date.format. You can use the Interface but that is AFTER the data is loaded.
I need to send a dynamic date to my json data source string to load data based on today's date.
{date.format("yyyy-MM-dd")}
GetTodaysDate = Text.From(Date.LocalNow()),
"05/20/2020"
I need it to be:
"2020-05-20"
Does DAX have a Date Format Function?
How do I convert the date using Text Replace or some other method?
Solved! Go to Solution.
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.