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