Forum Discussion

Mrafih's avatar
Mrafih
Frequent Visitor
3 years ago
Solved

Dax function for current date

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's avatar
    AnthonyGenovese
    3 years ago

    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!

     

     

2 Replies

  • AnthonyGenovese's avatar
    AnthonyGenovese
    Resolver III
    3 years ago

    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!

     

     

    • Mrafih's avatar
      Mrafih
      Frequent Visitor
      3 years ago

      It was PowerQuery sorry. It worked thanks!