Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Function not Working (DAX) (Power Query Editor)

Hi all, I'm try to use a few function like =TODAY(), CALENDAR and etc on Power Query Editor, but nothing is working like usualy. For exemple: I created a custom column and type = TODAY(), and t...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    The Power Query editor does not use DAX. It uses the case-sensitive M language which has entirely different functions.

     

    Try using DateTime.LocalNow() instead to get the current datetime or wrap that in Date.From(...) to get just the date component.

    =Date.From(DateTime.LocalNow())
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

The Power Query editor does not use DAX. It uses the case-sensitive M language which has entirely different functions.

 

Try using DateTime.LocalNow() instead to get the current datetime or wrap that in Date.From(...) to get just the date component.

=Date.From(DateTime.LocalNow())