SamePeriodLastYear only works if PivotTable has Year Month in ROW field but not when in Column

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
672
I am using this from sample on web to get for Mar, last year Mar amount:-


Last year:=CALCULATE(

SUM('Transaction'[Quantity]),

SAMEPERIODLASTYEAR(Calendar[Date])

)

It works only if the layout of my Pivot has Year and Month on Row Field.
However, my report layout is always
Year in page field, and Months on Column field.

I tried this layout with this measure then it render errors.
What can I do ?

Thanks in advance.
 

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
672
I found actually if I put both Year and Month as Column it works,
But if I move Year to Page field, this error comes up

'SAMEPERIODLASTYEAR' only works with contiguous date selections.
This is very strange as :-

Year and Month in column fields it works
Year in page and Month as Column then come to this error.

What can we do here ?
Thanks
 

Forum statistics

Threads
1,078,275
Messages
5,339,213
Members
399,286
Latest member
ossa

Some videos you may like

This Week's Hot Topics

Top