Forum Discussion
Solved
wrong % variation measure
Dear All, I have the following measures: 1) [IMP. RIGA TOT.] = SUM(Query1[IMP_RIGA]) 2) [Total Sales_PY_Sameday] = CALCULATE([IMP. RIGA TOT], DATEADD(CalendarTable[Date], -364, DAY)) Ba...
hi powerbricco
Instead of using DATEADD, why not use SAMEPERIODLASTYEAR?
Note: Dates table must be marked as such.
Hi powerbricco, have you tried to use SAMEPERIODLASTYEAR Dax Function? You may want to use MTD as well