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