IF Formula in Power BI

[Anonymous]

Hi All,

Im fairly new to Power BI and trying to build my own report/visual dashboard.

I have 1 dataset where i want to insert IF formula to compare if column A is greater than column B then return 1 else return 3.

Ultimately want to use the results  of this to create a traffic light using UNICHAR function.

However when doing the IF formula, it returns 3.10 where statement is true and blank where statement is false.

[speedramps · Accepted solution]

Hi majmsk 

Please consider one of these solutions and leave kudos

Method 1)

Add a conditional column in you M query

Method 2)

On the top menu bar>Click on Modelling>New measure and add these measures

Total last = SUM(YourTableName[Last])

Total current = SUM(YourTableName[Current])
Your flag = IF([Total current]>[Total last],1,3)

[harshnathani · Accepted solution]

Hi @Anonymous ,

You can try this measure.

Measure =

SWITCH(
TRUE(),
MAX('Table'[Last]) < MAX('Table'[Current]) , "3",

"1"

)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[adhumal2]

@AnonymousHi , Can you please send the sample file. It looks like some formatting issue

[speedramps · Accepted solution]

Hi majmsk 

Please consider one of these solutions and leave kudos

Method 1)

Add a conditional column in you M query

Method 2)

On the top menu bar>Click on Modelling>New measure and add these measures

Total last = SUM(YourTableName[Last])

Total current = SUM(YourTableName[Current])
Your flag = IF([Total current]>[Total last],1,3)