PY YTD and PY MTD

[Xclipse]

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

PeriodOverPeriodLastValue

Update: We were able to identify the issue. It was due to having a hidden column “year” which is the year number extracted from the date. The PeriodOverPeriod function groups by every field in the table. For example if I have a period over period function that’s looking back a year. Where my date is Jan 2022, and my year is 2022, then my period over period function will look for a value where date is Jan 2021 and year is 2022 which it will obviously never find resulting in the column always bein…