Forum Discussion
subburaj
Helper I
Helper IFinding 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) ...
subburaj ,
You need to convert the 6 measures to calculate columns and then create a measure using dax below:
SpoilerDiff = 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_2019Community 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.
