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 them the erro mensage is:  Expression.Error: The name 'today' wasn't recognized. Make sure it's spelled correctly.

Also, I identify that the auto-complet formula isnt working anymore.


Have someone with these same problem?

 

 

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())

1 Reply

  • 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())