topic Re: Dax function for current date in DAX Commands and Tips

Dax function for current date

Mrafih — Tue, 08 Aug 2023 19:59:28 GMT

Hi everyone,

My dashboard is using this dax function to pull a dataset from another aplication.

currently I have to input the current date manually, is there any way to replace the date "(2023, 8, 8)" with a funtion that would automatically put todays date?

Thanks!

Re: Dax function for current date

AnthonyGenovese — Tue, 08 Aug 2023 20:13:49 GMT

Are you sure that is dax and not PowerQuery?

If you need today's date using Power Query, use this. Date.From(DateTime.LocalNow())

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

Re: Dax function for current date

Mrafih — Tue, 08 Aug 2023 20:18:04 GMT

It was PowerQuery sorry. It worked thanks!