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)
