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