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 | 550 | December 18, 2023 | |
| How to calculate YOY % through certain date? | 3 | 5464 | June 9, 2022 | |
| Period Over Period Functions with Date Controls | 14 | 4476 | October 2, 2023 | |
| Issue with the KPI | 2 | 350 | August 25, 2023 | |
| How to customise the KPI cards | 6 | 448 | May 8, 2024 |