Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've the below set analysis code and now the requirement is to move the code into load script.
num(sum({<MonthDiff={"<12"},AsOfMonth={">=$(=Date(Yearstart(today(),-2),'YYYY-MM'))<=$(=Date(MonthEnd(today(),-1),'YYYY-MM'))"}>}Sales),'#,##0')
Can you help me out how to move this code into load script? Basically here we are calculation 12 months rolling sales.
create flags in your script,
for example -
TempTable:
NoConcatenate
load *, if (Date>Date(AddMonths(MonthDiff,-12)),1,0)
...
and after that, you can filter more easily