Dear Experts,
I need your help on a problem that has been bugging me:
Kindly download the attached PBIX file
If I wanted to do a Time-Series Analysis where I want to calculate the average Year-on-Year growth rate from 2023-2026 for the top 3 products in the latest year (Strawberry, Orange, Avocado), how would I go about it.
The goal is to have a matrix that shows Strawberry, Orange, Avocado and Others as fixed rows, change filter context and look back from the beginning of time what has been the growth trend for these 4 line items.
And if 2027 data comes in and Banana replaces Avocado, then the calculation should update itself and recalculate the growth trend for the new top 3 products and others
I had already started working on it, feel free to delete measures and start afresh.
Best regards,
Fundi
Fruit Sales Analysis.pbix (46.2 KB)