Forum Discussion
Solved
NaN help
I created a new field, Cost/Quantity, and the output is coming up at NaN. I was able to see the Cost by year on a bar chart and quantity by year on a bar chart fine, but when I tried to doing Co...
The query editor uses a different language. It is case sensitive and if statements have a different structure there. You should familiarize yourself with the query editor language. https://msdn.microsoft.com/en-us/library/mt211003.aspx
Oh, you're in the query editor. No, DIVIDE is a DAX function. You'll have to go with the if 0 suggestion from MarcelBeug after all.
Thanks. it says that the If function is not recognized? Should I move to DAX to do this?
The query editor uses a different language. It is case sensitive and if statements have a different structure there. You should familiarize yourself with the query editor language. https://msdn.microsoft.com/en-us/library/mt211003.aspx