Distinct values at max date

[Hoowling]

Hi community, 

In a chart, I want to calculate the "planned qty" per VKRIDN (order number) at the max date. 
An example of the raw data is found in below table.

 

Basically I want the chart to show 576 units on 2020-07-01. 
Currently I'm using this formula: Sum(aggr(sum(Distinct[Planned qty]),VKRIDN)) - which puts the quantity at 2020-06-30.

Any suggestions on how to include a max(Date) function in the set analysis above? 

Regards,
Hoowling

[tresesco]

May be you need implicit set like:

Sum({<Date*={"$(=Max({1} Date))"}>} [Planned qty])

Note the '*', intersection operator in red.