2 Date Columns and 2 Columns that need Summing/Count

[santoshreddyk95]

Hi 

Problem Statement is as below. 

there are 6 Columns in the data 

Plant Name

Product Name

Planned Date of Production

Planned Qty

Delivered Date of Production

Delivered Qty

Now I need to create a Visual that gives the following Output

Plant Name      Product Name     Planned qty     Delivered Qty     Deliveredqty/Planned qty 

The above Visual needs to be filtered basis a Date
The date selected should give me the  sum of Planned qty basis the Planned date and sum of delivered qty basis the Delivered Date
there are rows of data that have diffrent planned date and delivery date. 
Can anyone help me?

Thanks, 

Santosh

[amitchandak · Accepted solution]

@santoshreddyk95 , Single date table, joined with both Dates. Inactive joins. TO be activated using userelationship in measure

Assume Delivered  date join is inactive

Delivered QtyM = CALCULATE(Sum(Table[ Delivered Qty]),USERELATIONSHIP(Table[Delivered Date],'Table'[Date]) )

Refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...