Fixing start date in a cumulative measure

[Justas4478]

Hello, I am trying to create cumulative sales measure for my bi report but I am runing in to problem. Since my measure should only start caculating sales starting from 2021,06,01 - to date. I i keep getting error when trying to add specific date in to measure. would anyone know how to modify the measure? Thanks.

Cumulative Sales volume =

CALCULATE (

'Actuals'[Sales Volume],

FILTER (

ALLSELECTED ( 'Date' ),

DATE(2021,06,01) <= MAX ( 'Date'[Date] )

)))

[amitchandak]

@Justas4478 , Assume you have date in Actual Table

Cumulative Sales volume =

var _min = minx(allselected('Actual'), 'Actual'[Date])

return
CALCULATE (
'Actuals'[Sales Volume],
FILTER (
ALLSELECTED ( 'Date' ),
 'Date'[Date]<= MAX ( 'Date'[Date] ) && 'Date'[Date]>= _min
))

[Justas4478]

@amitchandak I does work. But sorry for stupid question where do I declate in a measure that  cumulative calculation should only read data starting from 2021,06,01 even if the table goes further back.

this is result with the sulution that you provided. I attached screenshot I hope it explains it well. Please send any questions if anything is unclear.

[amitchandak · Accepted solution]

@Justas4478 , Sorry, I got that part wrong. Check if this can help

Cumulative Sales volume =

var _min = date(2021,06,01)

return
CALCULATE (
'Actuals'[Sales Volume],
FILTER (
ALLSELECTED ( 'Date' ),
'Date'[Date]<= MAX ( 'Date'[Date] ) && 'Date'[Date]>= _min
))

[Justas4478]

@amitchandak It looks to be working well now. Thank you so much for help.