Forum Discussion

iioannou's avatar
iioannou
Helper I
8 years ago
Solved

SAMEPERIODLASTYEAR filter

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'))