Reply
Regular Visitor
Posts: 43
Registered: ‎06-07-2016
Accepted Solution

Expression.Error: The name 'CALCULATE' wasn't recognized. Make sure it's spelled correctly.

[ Edited ]

 

So, what am I doing wrong here? Smiley Frustrated

 

 Calculate error.png

 

 

 


Accepted Solutions
Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

Re: Expression.Error: The name 'CALCULATE' wasn't recognized. Make sure it's spelled correctly.

Hi @shanka,

 

As Vvelarde has mentioned above, you should use Power Query (informally known as "M") Formula in Query Editor.

 

The formula you're using should work when creating a calculate column or a measure under Modeling tab in Power BI Desktop.Smiley Happy

 

c1.PNG

 

Regards

View solution in original post


All Replies
Super User
Posts: 1,684
Registered: ‎05-10-2016

Re: Expression.Error: The name 'CALCULATE' wasn't recognized. Make sure it's spelled correctly.

@shanka

 

In Query Editor you should be use Power Query Language. 

 

Calculate is part of DAX. (to create a measure or calculated column after you load the data model)

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

Re: Expression.Error: The name 'CALCULATE' wasn't recognized. Make sure it's spelled correctly.

Hi @shanka,

 

As Vvelarde has mentioned above, you should use Power Query (informally known as "M") Formula in Query Editor.

 

The formula you're using should work when creating a calculate column or a measure under Modeling tab in Power BI Desktop.Smiley Happy

 

c1.PNG

 

Regards