Forum Discussion

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...

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.

Impactful Individual

5 years ago

Hello tashaq

The file is attached in the URL below for your reference.

https://drive.google.com/file/d/1IjgpKKVHXhdI8LQ9yddr5ZIR3svP7VdG/view?usp=sharing

Regards

Kumail Raza

Did this help? Kudos are appreciated

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

Impactful Individual

5 years ago

-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.

Related content