Forum Discussion
Sebastián
3 years agoNew Member
Subtotal includes blank values matrix
Hello! I made a measurement to calculate the comparison of sales from last year but day by day, that is, Monday to Monday, it worked for me but the total by month does not appear in the dynamic t...
amitchandak
Super User
3 years agoSebastián , with help from date/calendar table try a measure like
week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))