Hi Team,
I tried calculating Last Year Act as follows:
LY Actual =
CALCULATE(SUM(‘SummaryUnpivotWithDate’[Value]), DATEADD(DateTable[Date],-1,YEAR),FILTER(SummaryUnpivotWithDate, SummaryUnpivotWithDate[Act/Bud] = “Act”))
and my current year actual formula is as follows:
CY Actual =
CALCULATE(SUM(SummaryUnpivotWithDate[Value]),
FILTER(SummaryUnpivotWithDate, SummaryUnpivotWithDate[Act/Bud]= “Act”))
unfortunately, I do not have figures for LY Actual calculation.
Please let me know the area to check.
thank you.
Regards,
Aye
Hi Aye,
Unfortunately, the screenshot is tiny and unreadable.
Why don't you let the PivotTable provide contextual filtering and use SAMEPERIODLASTYEAR to get last year's actuals? It's not clear why you need to hard key the 'Act' filter. You could just add this to the row/column/filter area and let context do the filtering.
Mynda
Thanks for your reply, Mynda.
My date table was incorrect from the beginning and gave me anomalies. All good now.
Regards,
Aye
