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....
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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
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

dananjayaprasad's avatar
dananjayaprasad
Helper I
8 years ago

Thank you Angelia.