My dax measure is like this:
Sales LY = IF(ISBLANK([Net Sales]), BLANK(),
CALCULATE([Net Sales], DATEADD(‘Tab Dates’[Date], -1, YEAR)))
which means the total that i’m seing in the visual is giving me the total of all year instead of just the months that i’m seing…
The column Sales LY has a wrong total
Can it b fixed?