Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to calculate the difference of AHT between the two months for different categories. The AHT displayed is already a measure and i am using a month slicer to filter the data as per months.
Category | October AHT | November AHT |
A | 2.65 | 2.75 |
B | 2.35 | 2.45 |
C | 1.28 | 1.64 |
D | 1.78 | 1.45 |
E | - | 2.14 |
F | 1.91 | 1.95 |
G | 1.17 | 0.72 |
H | 2.65 | 3.14 |
I | 1.43 | 1.59 |
what i want to accomplih is this.
Category | October AHT | November AHT | Difference |
A | 2.65 | 2.75 | -0.10 |
B | 2.35 | 2.45 | -0.10 |
C | 1.28 | 1.64 | -0.36 |
D | 1.78 | 1.45 | 0.33 |
E | - | 2.14 | - |
F | 1.91 | 1.95 | -0.04 |
G | 1.17 | 0.72 | 0.45 |
H | 2.65 | 3.14 | -0.49 |
I | 1.43 | 1.59 | -0.16 |
This is an just an example of this month and the month prior. The month slicer has other months too and the difference should change based on the months selected in the slicer. Thank you for you help!!
hi, @allwin_1510
What is your data structure? do you mean that you select two months then calculate the difference between two months?
If so, if you select three or more months, how to calculate the difference?
if not, do you mean that calculate difference between two consecutive months?
you could create a date table then use PREVIOUSMONTH to create a measure bease on [AHT]
like
If it is not your case, please share sample pbix file or some data sample and expected output . You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
So do you actually have an October AHT measure and another November AHT measure or is it just one measure?
Just one measure for all months
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |