Solved: Dax function for current date

Mrafih · ‎08-08-2023

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!

AnthonyGenovese · ‎08-08-2023

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!

View solution in original post

AnthonyGenovese · ‎08-08-2023

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!