12-18-2015 04:42 AM
I am attempting to add a simple column to show true or false if another column is greater than 2. I have written the formula as :
However, the edit window accepts it, but when i press OK - and go back to the query editor it wont accept it and says :
"Expression Error:The name 'IF' wasn't recognised. Make sure it's spelled correctly."
I dont understand, how it can be valid syntax - before clicking OK and then invalid afterwards?
Solved! Go to Solution.
12-18-2015 05:59 AM
Should both work,
at a guess doing it in power query may help performance as it will only need to get calculated during import, I'm not sure if doing it within powerpivot will mean its being calculated everytime you refresh your visuals or not.
12-18-2015 07:38 AM
If I wanted to compare a column against a hard coded date, how would I write that formula?
if date(2013,4,1)<[Date__c]then 1 else 0
Gives me an error that date isn't recognized.
12-18-2015 08:20 AM
Use the datevalue function in DAX to convert the hard coded date string to a date type
If you did this in poswer query the syntax is different
10-31-2016 05:33 AM
This worked for me. I was trying to evaluate if the value is >=500 000 or <500 000.
This formula didn’t work from PowerPivot: =IF([DisplayCost]>=500000,">=R500 000","<R500 000")
This Worked: if[DisplayCost]>=500000then">=R500 000"else"<R500 000"