Forum Discussion

apatwal's avatar
apatwal
Helper III
4 years ago
Solved

Help in Creating a calculated Column or Measure

Hi,   I am new to Power Bi and need help in creating measure to include status column which includes Decrease if Revenue 2020 > Revenue 2021 else Increase for each combination of customer and produ...
calculated column
DAX
DAX Commands and Tips
Help me
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi apatwal ,

     

    You can create a measure with below code:-

    Status =
IF (
    SUM ( 'Table (3)'[revenue 2021] ) < SUM ( 'Table (3)'[revenue 2020] ),
    "Decrease",
    "Increase"
)

     

    Output:-

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi apatwal ,

 

You can create a measure with below code:-

Status =
IF (
    SUM ( 'Table (3)'[revenue 2021] ) < SUM ( 'Table (3)'[revenue 2020] ),
    "Decrease",
    "Increase"
)

 

Output:-

 

Thanks,

Samarth