I keep getting the same results for the current period and the prior period.
My formulas are:
Total Cost = sum(Data[Claim_Cost])
Total Cost LY = Calculate([Total Cost],SAMEPERIODLASTYEAR('Date'[Date].[Date]))
When I drop these two measures into a table visual, I get the same value for each month/year.
e.g.
Jan 2015 - Shows 39M for both Total Cost and Total Cost LY.
Whereas Jan 2015 was 39M and Jan 2014 was 34M
Thank you.
My formulas are:
Total Cost = sum(Data[Claim_Cost])
Total Cost LY = Calculate([Total Cost],SAMEPERIODLASTYEAR('Date'[Date].[Date]))
When I drop these two measures into a table visual, I get the same value for each month/year.
e.g.
Jan 2015 - Shows 39M for both Total Cost and Total Cost LY.
Whereas Jan 2015 was 39M and Jan 2014 was 34M
Thank you.