Date Format in DAX Advance Settings before loading data

[landcruiser64]

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?

[camargos88 · Accepted solution]

Hi @landcruiser64 ,

Try this one:

DateTime.ToText(DateTime.LocalNow(), "yyyy-MM-dd")