Forum Discussion

tashaq's avatar
tashaq
Regular Visitor
5 years ago
Solved

YoY Calculation for non cumulative data

Hi,   First time poster so apologies if this is in the wrong place.   I have annual data which is defined at source as academic years (15/16, 16/17 etc) and Ive added a lookup to convert these to...
Need Help
  • Kumail's avatar
    Kumail
    5 years ago

    tashaq 

     

    -You needed to create the relationship in the model between Year Lookup table and DateTable.

     

    Regards

    Kumail Raza

    Did this help? Kudos are appreciated.

    Consider Accept it as the solution to help the other members find it more quickly.

    • Kumail's avatar
      Kumail
      Impactful Individual
      5 years ago

      tashaq 

       

      -You needed to create the relationship in the model between Year Lookup table and DateTable.

       

      Regards

      Kumail Raza

      Did this help? Kudos are appreciated.

      Consider Accept it as the solution to help the other members find it more quickly.

    • tashaq's avatar
      tashaq
      Regular Visitor
      5 years ago

      Thank you Kumail, thats great.

       

      Just so I understand going forwards, and so i can replicate this for other measures, was the issue simply the reference being used for the 'Year', rather than any issues with the measures or the dateTable itself?