Forum Discussion
iioannou
8 years agoHelper I
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'))
1 Reply
- v-chuncz-msftCommunity Support