Forum Discussion

subburaj's avatar
subburaj
Icon for Helper I rankHelper I
7 years ago
Solved

Finding delta for all measures

Hi Friends - Please see below screenshot for yoru reference.  I would like to create a measure called "Delta" whichc is a difference between 2020 - 2019. and it should come on columns (next to 2020) ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    subburaj ,

     

    You need to convert the 6 measures to calculate columns and then create a measure using dax below:

    Spoiler
    Diff = 
VAR Percentage_2019 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2019))
VAR Percentage_2020 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2020))
RETURN
Percentage_2020 - Percentage_2019

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

subburaj ,

 

You need to convert the 6 measures to calculate columns and then create a measure using dax below:

Spoiler
Diff = 
VAR Percentage_2019 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2019))
VAR Percentage_2020 = CALCULATE(MAX('Table'[Percentage]), FILTER(ALLEXCEPT('Table', 'Table'[Measure]), 'Table'[Year] = 2020))
RETURN
Percentage_2020 - Percentage_2019

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.