Cumulative data on a period

Hi Anonymous ,

Please try below steps:

1. below is my test table

Table:

Date:

Date = CALENDAR(FIRSTDATE('Table'[Date]),LASTDATE('Table'[Date]))

Model:

2. create a measure with below dax formula

Measure =
VAR cur_date =
    SELECTEDVALUE ( 'Table'[Date] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), [Date] <= cur_date )
RETURN
    SUMX ( tmp, [Value] )

3.  add a table visual with Table field and measure, add a slicer visual with Date table field

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.