automatically set todays date to a parameter in format YYYY-MM-DD

[NaddingGod]

i need to set a parameters value automatically to todays date, in the format YYYY-MM-DD

[Anonymous]

Hi @NaddingGod ,

Are you talking about Power Query parameter? If so, I doubt that you could do that. Would you consider creating a custom column and using this column as a filter instead?

Date.ToText(Date.From(DateTime.LocalNow()),"YYYY-MM-DD")

Best Regards,

Jay

[amitchandak]

@NaddingGod , date format you can choose in format under column tools .

TO set default today you have to create a flag 

Is Today = if('Date'[Date]=TODAY(),"Today",format([date], "YYYYMMDD")

you have select today in the slicer

[NaddingGod]

Hello thanks for the answer.

i am not concerned with the date format. How do i set todays date to a parameter. i want it to chage automatically, with every refresh in my json api.