11 Replies Latest reply on Sep 11, 2019 12:57 PM by Utkarsh Agrawal

    'Difference' Table Calc query

    Utkarsh Agrawal



      I am working on a calc to show me difference of a certain measure for [Month]2019 - [Month]2018. It is working as expected, but when I do this in table for 2 or more year, the oldest year would have figures not as expected.


      Below is the picture of when all the years are selected in filter. Notice the figures in year 2018.

      Below is the snap of when 2017 is unchecked.


      The figures here change. I am trying to understand what is the reason behind it also what are the figures in 2017 when the data for 2016 doesn't exist.


      You can check the table calc in the attached workbook to see what exactly I am doing. Please let me know if I need to elaborate.