Forum Discussion
Solved
Rolling total Not Working Correctly
hi, I have this calculation for the same day sales. the result is correct. Sales R3M Same Day = VAR _currentdate = MAX ( DateTable[Date]) VAR _day = DAY ( _currentdate ) VAR _previous...
Sumx(
FILTER(
ALLSELECTED('DateTable'[Year Month]),
'DateTable'[Date] <= MAX('DateTable'[Date])
),
[Sales R3M Same Day]
)
Something like this, calculate the measure per year month and sum the values.
Linnox Try using
DAX
Sales R3M Same Day running total in Date =
CALCULATE(
[Sales R3M Same Day],
DATESINPERIOD(
'DateTable'[Date],
LASTDATE('DateTable'[Date]),
-1,
MONTH
)
)