Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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) showing delta between 2019 and 2020 for ALL 6 measures not just 1. Kindly help
Solved! Go to Solution.
You need to convert the 6 measures to calculate columns and then create a measure using dax below:
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.
You need to convert the 6 measures to calculate columns and then create a measure using dax below:
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |