comparing current totals to last year totals based on a date filter

[Sebastian]

Hi all,

I hope some could help me.

I have a matrix visual which consists of two measures. The first measure shows the total amount of the current year

and the second measure calculates the total amount for the same period in the last year.

The Period is choosen in a Filter visual. The total amount for the current year is right but for the last year is wrong. Could someone help?

1.Measure

CurrentAmount = Sum(Amount)

2.Measure

AmountLY = Calculate(sum(Amount);Sameperiodlastyear(Calender[Date]))

[PavelR · Accepted solution]

@Sebastian

maybe this topic could help.

Regards.

Pavel