Hi everyone, I’m currently trying to calculate a PY YTD and PY MTD metric for a sum of XEVs variable. I’ve tried many different ways, either by creating a field for PY date (vehicle_retail_date_py), either by calculating it by hand, and the closest I managed to achieve, is the following code, but I …

@GabrielLF , is this issue resolved? Do you still need help with PeriodOverPeriodLastValue. This post maybe of help: [image] PeriodOverPeriodLastValue Question & Answer Update: We were able to identify the issue. It was due to having a hidden column “year” which is the yea…

PY YTD and PY MTD

Q&A

Xclipse July 15, 2024, 2:51pm 6

@GabrielLF, is this issue resolved? Do you still need help with PeriodOverPeriodLastValue. This post maybe of help:

Topic		Replies	Views
Peroidtodatesum does not include end date? Q&A calculations	4	396	January 17, 2023
addDateTime function error: not matching given name and argument type Q&A error	3	453	November 18, 2022
Can one create a date constant in a QuickSight calculation Q&A calculations , how-to	3	765	August 23, 2022
Previous Year YTD Aggregation functions Q&A analysis , calculations , how-to	1	1684	April 28, 2023
YTD Calculations with different time periods, within the same visual Q&A calculations	4	2982	February 2, 2023

PY YTD and PY MTD

Related topics