To get qty from latest issue date based on its delivery date

[Izzati_Riza]

Hi, PLEASE HELP ME!!!

how can i generate formula to get qty based on issue date based on its delivery date?

i have done formula like below however , it also take value for 10 jan23 delivery date.

var latest_date=MAX('Table1'[Issue date])
return
CALCULATE(SUM('Table1'[Convert qty (kpcs)]),'Table1'[Issue date]=latest_date)

[amitchandak]

@Izzati_Riza , Not very clear. But if you want both dates to respond to same date filter, you need to have a common date table and join both tables, one join will be inactive, that you can activate using userelationship

example

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...