Forum Discussion
Solved
Sum Difference between different date intervals
Hi everyone, I'm trying to create a measure that calculates the % increase/decrease between the sum of operating profit month to date, and the sum of operating profit during the same time period ...
You haven't mentioned the table and column names, but it should be something like this.
profit last month td = CALULATE(SUM(fact_table[sales]),DATEADD(DATESMTD('date_table'[date]),-1, MONTH))
You haven't mentioned the table and column names, but it should be something like this.
profit last month td = CALULATE(SUM(fact_table[sales]),DATEADD(DATESMTD('date_table'[date]),-1, MONTH))
Thank you sjoerdvn, somebody on a different forum suggested the exact same solution and it worked.