Forum Discussion
DAX Query - Temp Table Filter Measure - Previous Year Sum
Hi Community, Im looking to create a Temp Table In Dax that collects a date range and be able to specify such range in lower measure, Is there a way to do this? The code I have is the follow...
Mark_Timson , for same day last year, have you tried like ?
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))