Forum Discussion
Solved
Calculate last year based on current year filter
Hi, Let's say i have a table called Orders with number of units sold by resellers in Country by date Country ResellerID Date Units 3 1 May-17 7 3 ...
It looks like this one does the trick
= CALCULATE(SUM(Orders[Units]), SAMEPERIODLASTYEAR(Orders[Date]), Orders[ResellerID] IN VALUES(Orders[ResellerID]))
It looks like this one does the trick
= CALCULATE(SUM(Orders[Units]), SAMEPERIODLASTYEAR(Orders[Date]), Orders[ResellerID] IN VALUES(Orders[ResellerID]))