Forum Discussion

iDataDrew's avatar
iDataDrew
Advocate IV
8 years ago
Solved

Dynamic date range/line chart...

I've created a dynamic measure of # of days.  When you select the number of days you want, the report compares the current value to the value in the past (the # of days in the past).  I have no probl...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi iDataDrew,

     

    You can try to use below formula to get last month running total.

    LM Total= 
var currentDate=MAX('Table'[Date])
return
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),[Date]>=DATE(YEAR(currentDate),MONTH(currentDate)-1,DAY(currentDate))&&[Date]<=currentDate))

     

    Please ensure your formula not contain any specific date filter which can broke the current filter.(all allexcept)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi iDataDrew,

 

You can try to use below formula to get last month running total.

LM Total= 
var currentDate=MAX('Table'[Date])
return
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),[Date]>=DATE(YEAR(currentDate),MONTH(currentDate)-1,DAY(currentDate))&&[Date]<=currentDate))

 

Please ensure your formula not contain any specific date filter which can broke the current filter.(all allexcept)

 

Regards,

Xiaoxin Sheng