Difference from Previous Parallel Period with _ToDate_ and dynamic date

[moirafascioli]

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)

[sbxkoenk]

Hello @moirafascioli ,

I have moved your post to the "SAS Visual Analytics"-board.

Koen