Forum Discussion

leinad13's avatar
leinad13
Advocate I
10 years ago
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...
Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    10 years ago
    Excel=IF(test, value_if_true, value_if_false)
    Power Query=if test then value_if_true else value_if_false
leinad13's avatar
leinad13
Advocate I
10 years ago

I think i was being a bit of an eejit and trying to do this in Query editor instead of the data dashboard or whatever it is called.

 

Anyway, all sorted!

  • itchyeyeballs's avatar
    itchyeyeballs
    Impactful Individual
    10 years ago

    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.