IF and Else Conditional formatting

[dananjayaprasad]

Hey Guys, 

I ran into another problem. I have Calculated colunm called Sunday Sug.Hr. Please see below picture and formular that I used to calculate' 

(Sunday Sug.Hr = 'Traffic by Month'[Sunday.] *RELATED('This Month'[Payroll Hours Based on GP]))

Besed on the result I want to show, 

if result = 0 then "0"

if result <8 then "8"

Else whatevether result 

 I tried several ways. its give me an error, (Ex IF AND, etc)

Column = SWITCH(('Traffic by Month'[Sunday.] * RELATED('This Month'[Payroll Hours Based on GP])) = 0,0,('Traffic by Month'[Sunday.] * RELATED('This Month'[Payroll Hours Based on GP])) < 8,8)

Thank you So much 

Dhana 

[v-huizhn-msft · Accepted solution]

Hi @dananjayaprasad,

You just need to create a calculated column based on the column "Sunday Sug.Hr" using the formula below.

Column =
IF (
    'Traffic by Month'[Sunday Sug.Hr] = 0,
    0,
    IF (
        'Traffic by Month'[Sunday Sug.Hr] < 8,
        8,
        'Traffic by Month'[Sunday Sug.Hr]
    )
)

Best Regards,
Angelia

[dananjayaprasad]

Thank you Angelia. 

[Peter_R]

As an alternative for using those ugly nested IFs, the SWITCH function has some neat tricks - see https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/