Forum Discussion
Helper IOverall Satisfaction Year on Year difference
Good Afternoon,
I have a matrix table that has survey question from this year and last year and I need to idicate whether the score has gone up or down on the percentage of satisfaction. The overal satisfaction measure is a calculation that counts if respondent Strongly Agrees or Agrees, which works perfectly. When I add the year in it also works perfectly, I am trying to now add a difference column in. So in Rows i have Q's, Columns I have Year, Values I have % Overall (overall measure is (% Overall = [4&5Agree]/Overal Totals 1-5]. I've tried previous date etc... but think I need to make 2 x % Overall one for 2024 and another for 2023 and then cal difference unless anyone has suggestions. Thank you
| 2023 | 2024 | Diff % | |
| Q1 | 75% | 62% | -17.3% |
| Q2 | 85% | 86% | 1.2% |
| Q3 | 50% | 50% | 0.0% |
Thank you, managed to get this to work. Very simple in the end. Created three seperate measure, one to count 2023, and other 2024, and then just a percentage diff for the third
3 Replies
- amitchandak
Super User
Suzie_Suze_Sue1 , if you are using a date table you can have diff measure and switch in GT, in case you are using year on column from date table
if(isinscope(Date[Year]), [Measure], divide([Measure] - CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-4,QUARTER)) , CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-4,QUARTER)) ) )
else you can create the same last year's measure using a separate qtr year table. Make sure you use year, qtr from date or qtr year table
Last year Qtr = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'), 'Date'[Year]=max('Date'[Year]) && 'Date'[Qtr]=max('Date'[Qtr]) ))
and use in same measure like above
Suzie_Suze_Sue1Thank you for the response.
I am finding it hard to create a difference measure. The response table is like this
Year ResponseID Question1 Rating 2024 R_8WORaVEsXbxhxy3 Question 1
4 2024 R_8XgPAmjgKQ4LY63 Question 2 3 2024 R_8ydUBJ9RtRw1JYd Question 3 4 2024 R_8YEcQhDWrdf60eZ Question 4 4 2023 R_1Ho65FSthee3hNj3 Question 5 5 2023 R_1Ho65OKOLP3hPL4 Question 6 4 2023 R_1Ho65FSCAZ3hjk9 Question 7 5 2023 R_1Ho65FSCAZ3hwE4 Question 8 5 I have a measure which is called Overall % which is a percentage of those answer 4 or 5 compared against the totals I have tried what I think you mean above and it just isn;t working or I am doing something wrong.
I can pull throurhg the following table but ideally would like to add a difference column
2023 2024 Question 1 75% 62% Question 2 85% 86% Question 3 50% 50% Similar to this which is in excel
2023 2024 Difference Question 1 75% 62% -17.30% Question 2 85% 86% 1.20% Question 3 50% 50% 0.00% I have a date table, but just doesn't seem to like it when I am using the measure withn the diff measure.
Thanks
- Suzie_Suze_Sue1
Thank you, managed to get this to work. Very simple in the end. Created three seperate measure, one to count 2023, and other 2024, and then just a percentage diff for the third
