Forum Discussion

AlexIsac16's avatar
AlexIsac16
Regular Visitor
3 years ago
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 ...
  • sjoerdvn's avatar
    sjoerdvn
    3 years ago

    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))