SAMEPERIODLASTYEAR filter

[iioannou]

Hello,

Is there a way to use SAMEPERIODLASTYEAR with filter so that I can get specific values... For example see my query below - it sums up everything - I would like to get the SUM for all records based on the date but also based on another column value which will contain e.g Code = 101

eg.

NetRevenue LY = CALCULATE(SUM('Daily Revenue Accommodation'[NetRevenue]), SAMEPERIODLASTYEAR('Daily Revenue Accommodation'[RevenueDate]),ALL('Daily Revenue Accommodation'))

[v-chuncz-msft · Accepted solution]

@iioannou,

Just add an additional filter to CALCULATE Function.