Rolling total Not Working Correctly

Question

hi, I have this calculation for the same day sales. the result is correct.&nbsp;Sales R3M Same Day =VAR _currentdate =&nbsp; &nbsp; MAX ( DateTable[Date])VAR _day =&nbsp; &nbsp; DAY ( _currentdate )VAR _previousmonthenddate =&nbsp; &nbsp; EOMONTH ( _currentdate, -1 )VAR _twomonthsbeforeenddate =&nbsp; &nbsp; EOMONTH ( _currentdate, -2 )VAR _threemonthsbeforeenddate =&nbsp; &nbsp; EOMONTH ( _currentdate, -3 )RETURN&nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; SUM ( Sales[Invoices] ),&nbsp; &nbsp; &nbsp; &nbsp; DAY ( DateTable[Date] ) = _day,&nbsp; &nbsp; &nbsp; &nbsp; EOMONTH (DateTable[Date], 0 ) = _previousmonthenddate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || EOMONTH (DateTable[Date], 0 ) = _twomonthsbeforeenddate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || EOMONTH ( DateTable[Date], 0 ) = _threemonthsbeforeenddate&nbsp; &nbsp; )&nbsp;Now, i need to create a rolling total for the month out of the&nbsp;Sales R3M Same Day output.&nbsp;I created a quick measure:Sales R3M Same Day running total in Date =CALCULATE(&nbsp; &nbsp; [Sales R3M Same Day],&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('DateTable'),&nbsp; &nbsp; &nbsp; &nbsp; 'DateTable'[Date] &lt;= MAX('DateTable'[Date])&nbsp; &nbsp; ))&nbsp;But the output of this rolling total is giving me the same result as that of the&nbsp;Sales R3M Same Day.&nbsp;Can you help correct the Rolling total calc?

deku · Accepted Answer

Sumx(FILTER(ALLSELECTED('DateTable'[Year Month]),'DateTable'[Date] &lt;= MAX('DateTable'[Date])),[Sales R3M Same Day])&nbsp;Something like this, calculate the measure per year month and sum the values.&nbsp;

Forum Discussion

Rolling total Not Working Correctly