Forum Discussion
Solved
IF - Formula in Add Custom Column
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 : =IF([Spec]>2,true,false)) However, the edit window accepts it...
Excel =IF(test, value_if_true, value_if_false) Power Query =if test then value_if_true else value_if_false
| Excel | =IF(test, value_if_true, value_if_false) |
| Power Query | =if test then value_if_true else value_if_false |
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.
Use the datevalue function in DAX to convert the hard coded date string to a date type
https://msdn.microsoft.com/en-us/library/ee634543.aspx
If you did this in poswer query the syntax is different
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"
