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 build dynamic calculation for WOW, MOM, YOY, and QOQ calculation on the basis of date parameter? | 3 | 521 | December 18, 2023 | |
| How to calculate YOY % through certain date? | 3 | 5418 | June 9, 2022 | |
| Period Over Period Functions with Date Controls | 14 | 4397 | October 2, 2023 | |
| Issue with the KPI | 2 | 345 | August 25, 2023 | |
| How to customise the KPI cards | 6 | 403 | May 8, 2024 |