cumulative total on the basis of date slicer

[Anonymous]

Hi,

My desired result is to get a row in the report in PowerBI desktop with two columns Item Number and Quantity where the quantity should be cumulative on the basis of date as a slicer. (For example: If I select a date, say 10-02-2020 in the slicer then the report should show only a single row with the columns, Item number 41225 and Quantity 25). For reference, the below dataset is there.

Kindly help how to achieve the desired result, whether I should write a Dax or any other way. 

Item number		Date		Quantity
41225		10-01-2020		5
41225		10-02-2020		15
41225		10-04-2020		-5
41225		10-08-2020		25
41225		10-10-2020		-5

[Anonymous]

Paul Zheng,

Thank You for your support.

[V-pazhen-msft · Accepted solution]

@Anonymous 
You can create a measure, I guess you mean Quantity = 20 if you select 2020.10.2

Measure = CALCULATE(SUM([Quantity]),FILTER(ALL('Table'),[Date]<=MAX([Date])))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Just drag Date to a slicer and drag Quantity to a visual and you are done

[Anonymous]

NO only drag will not give the cumulative of quantity depending on the slicer.