Forum Discussion
2 Date Columns and 2 Columns that need Summing/Count
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
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
1 Reply
- amitchandak
Super User
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