Forum Discussion
Emulating Excel CountIfs
Hi - I am realy struggling with this, have seen a number of posts that almost solve it but I just can't get it to work. Difficult to explain why I need this without writing an entire essay, but belo...
Hi v-yajiewan-msft
I still get the message ""Expression.Error: The name 'CALCULATE' wasn't recognized. Make sure it's spelled correctly."
Hi AlanMB,
Ensure you're not using CALCULATE in the Power Query Editor.
CALCULATE is a DAX function and should be used in calculated columns or measures within the Data Model, not in Power Query (which uses M language).
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.