First convert the Year to date , you can find an example here : How can I make a formula that counts me in a 12 months rolling? - #9 by KLIKIN
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
How to calculate YOY % through certain date? | 3 | 5306 | June 9, 2022 | |
How to build dynamic calculation for WOW, MOM, YOY, and QOQ calculation on the basis of date parameter? | 3 | 493 | December 18, 2023 | |
Period Over Period Functions with Date Controls | 14 | 4236 | October 2, 2023 | |
Issue with the KPI | 2 | 340 | August 25, 2023 | |
Need help to replicate Year over Year - when KPI is a calculated field | 15 | 3002 | June 6, 2023 |