Forum Discussion
landcruiser64
6 years agoFrequent Visitor
Date Format in DAX Advance Settings before loading data
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?
1 Reply
- camargos88Community Champion