Forum Discussion

Suzie_Suze_Sue1's avatar
Suzie_Suze_Sue1
Icon for Helper I rankHelper I
2 years ago
Solved

Overall 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 ...
Need Help
  • Suzie_Suze_Sue1's avatar
    Suzie_Suze_Sue1
    2 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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_Sue1's avatar
    Suzie_Suze_Sue1
    Icon for Helper I rankHelper I
    2 years ago

    Thank you for the response.

    I am finding it hard to create a difference measure. The response table is like this

    YearResponseIDQuestion1Rating
    2024      R_8WORaVEsXbxhxy3      

    Question 1         

    		     4
    2024R_8XgPAmjgKQ4LY63Question 2     3
    2024R_8ydUBJ9RtRw1JYdQuestion 3     4
    2024R_8YEcQhDWrdf60eZQuestion 4     4
    2023R_1Ho65FSthee3hNj3Question 5     5
    2023R_1Ho65OKOLP3hPL4Question 6     4
    2023R_1Ho65FSCAZ3hjk9Question 7     5
    2023R_1Ho65FSCAZ3hwE4Question 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 285%86%
    Question 350%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