Getting total of a SUM based on a specific data range

[Anonymous]

Hello everyone!

I have a question that I couln't figure for myself.

I need to set in "DATA_CAPTURA" a specific time like "01/07/2022 to 01/07/2022". but, my "QTD_ATND_2 (it's basically a SUM) "need to be "70".

If I change my range in "DATA_CAPTURA" to 01/07/2022 to 31/07/2022 I will only get what is beetween this two values. But I need everthing that is before "31/07/2022".

 

Best Regards,

Daniel.

[AntrikshSharma · Accepted solution]

@Anonymous Try this:

VAR LastSelectedDate = 
	CALCULATE ( 
		MAX ( Dates[Date] ), 
		ALLSELECTED ( Dates[Date] ) 
	)
VAR Result = 
	CALCULATE ( 
		[QTD_ATND_2],
		Dates[Date] > LastSelectedDate
	)
RETURN 
	Result