Forum Discussion

landcruiser64's avatar
landcruiser64
Frequent Visitor
6 years ago
Solved

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