cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shanka Regular Visitor
Regular Visitor

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

 

So, what am I doing wrong here? Smiley Frustrated

 

 Calculate error.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

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

2 REPLIES 2
Highlighted
Vvelarde Super Contributor
Super Contributor

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!




v-ljerr-msft Super Contributor
Super Contributor

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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 356 members 3,925 guests
Please welcome our newest community members: