Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi! I'm trying to create a measure to calculate the % change of value based on my slicer selections (which is not in date format).
Here's the sample of my data. My slicer will be "Semester" and I would like to calculate the difference between value based on the selected semesters (up to all of them). For example, if i select semester AH2019 and AH2021, it will show -8% decrease. if i select AH2019, AH2020, AH2021, it will show the % change between all 3 semesters (18.57%, -22%).
Semester | Value | % difference |
AH 2019 | 7000 | |
AH 2020 | 8300 | |
AH 2021 | 6400 | |
SS 2019 | 10200 | |
SS 2020 | 18202 | |
SS 2021 | 8100 |
Please kindly assist. Your help is much much appreciated.
Please check if these results are correct.
Hello! Yes! Similar. I am trying to show something like this and would like to add the formula for the percentage change.
can you explain in detail how you got it -8%
what was taken away and what was divided.
show in numbers how it turned out -8%
-8% is (6400/7000)-1, the difference between just AH2021 and AH 2019, where 2021 is the newer value based on the year
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
50 | |
38 | |
38 |
User | Count |
---|---|
195 | |
80 | |
70 | |
51 | |
42 |