Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have one set expression which is not working in Sense
SUM({$<FinancialYear=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)} ,
[Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}
>}[Sales])
Can anyone help me out.
Thanks