Forum Discussion

dananjayaprasad's avatar
dananjayaprasad
Helper I
8 years ago
Solved

IF and Else Conditional formatting

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 

Need Help
Show and Tell
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

3 Replies