Cumulative sum based on date range slicer and group by

[navin1491]

I have 2 employees and the sales values ordered by date in the table. I want to create a table where I filter by date and the cumulative sales per employee should be displayed for the corresponding date.

Employee sales table

max_selected = MAX(Query1[Date])

min_selected = MIN(Query1[Date])

Measure= 
CALCULATE(
    (SUMX(VALUES(Query1[ID]),CALCULATE(SUM(Query1[Sales])))),
    FILTER (ALL(Query1),
        [Date] >= [min_selected]
            && [Date] <= [max_selected]
    ))

Can someone please help me here?