I want to calculate values ​​from the past up to the date I selected.

[Sxbbb]

I want to calculate values ​​from the past up to the date I selected. 

EX1   If Select date 04/05/2023 will calculate from past to 04/05/2023  OR

If Select date 03/01/2023 will calculate from past to 03/01/2023 

The code used but the value is invalid.

Sum({<DATE = {'>=01/01/2012'},> }TOTAL  Retest *Testing) 

I want the red date to change according to the selected date.

I want to calculate values ​​from the past up to the date I selected. 

[_Iswarya_]

Hi @Sxbbb 

Try like this:

=sum({$<DATE ={ ">=$(=min(DATE ))" }>} TOTAL  Retest *Testing)

[Sxbbb]

Invalid, value is 0 

I want to calculate data from the past to a selected date. 

[_Iswarya_]

Sorry, try this way:

sum({$<Date={"<=$(=max(Date))"}>} your measure)