Forum Discussion
Overall Satisfaction Year on Year difference
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
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
Thank 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