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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Please Try This Measure 

Status = 
VAR _R2020 = SELECTEDVALUE('Table'[Revenue 2020])
VAR _R2021 = SELECTEDVALUE('Table'[Revenue 2021])
VAR RESULT  = SWITCH(TRUE(),_R2020>_R2021,"Decrease","Increase")
return RESULT