Hi everybody, I want to use the Difference from previous parallel period, calculation available on Visual Analytics. I tried with the _ToDate_ parameter, inserting manually a date, in the screen you can see I put 08MAY2023 and it works fine. But I have to insert a dynamic date, in particular I've to put the max date of my calendar date dimension (calendar_day_date) of the table I am analyzing. Is it possibile to do that? How can I do? This is the code: ParallelPeriod(_Sum_, 'net_sales_euro'n,_IgnoreAllTimeFrameFilters_, 'calendar_day_date'n, _Inferred_,_Inferred_, 0, _ToDate_, '8MAY2023'd) - ParallelPeriod(_Sum_,'net_sales_euro'n, _IgnoreAllTimeFrameFilters_,'calendar_day_date'n, _Inferred_, _Inferred_, -1, _ToDate_,'8MAY2023'd)
... View more