Trend Line for 2 different date columns

[Anonymous]

I have 2 different date columns but would want to show a trend line with them.  

So I have Stop Planned Date and Stop Delivery Date.  

I would have the below table

Stop Number	Stop Planned Date	Planned Qty	Delivery Date	Delivered Qty
1	5/12/2021	10	5/12/2021	6
2	5/13/2021	12	5/14/2021	8
3	5/14/2021	10	5/15/2021	10

So  I would want a trend chart that would show

5/12 10 planned but 6 delivered

5/13 12 planned and 0 delivered

5/14 10 planned and 8 Delivered

5/15 0 Planned and 10 delivered

How can I do this?  Any tips would be appreciated

[amitchandak · Accepted solution]

@Anonymous , Create a common date table and join both dates with that. One join will be inactive which you can activate in a measure using userelationship

refer to blog for similar example and code

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970