undefined

[Anonymous]

Hello Experts, I need your help & Guidance on this Power BI issue. 

I have 3 different tables in power BI: 

From the above table, I am trying to create a Table in Power BI that will tell me for today's shipment Date, how much was on the Sales Order vs what we produced (In both locations) vs what was picked

See, the result I want is 

However, I tried 2 ways to get the Day before Yesterday's PF number.
1. Adding new measure 

DB Yesterday PF = sumx(filter('Finished Production Orders', 'Finished Production Orders'[Location_Code]="PF"), 'Finished Production Orders'[FinQty])
I am getting the sum of all PF across to date. I tried adding a date filter as per the below but it's nothing coming up it stays Blank (no numbers are coming up)
2. Adding quick measure:

FinQty for PF =

CALCULATE(

    SUM('Finished Production Orders'[FinQty]),

    'Finished Production Orders'[Location_Code] IN { "PF" }

)
But I am black every time I add one more filter for the date. 


How can I get the sum for each item for Yesterday's CC location & Day before Yesterday's PF location link with today's shipment date?
If I select today's shipment date from Example for item 101200 then I was as per below
Date Filter - Shipment Date (Reference Sales Order Table)
Item Number (Reference Sales Order Table)
Quantity on Sales Order (Reference Sales Order Table)
Quantity Produced yesterday at CC Location  -- NEED HELP
Quantity Produced Day before Yesterday at PF Location  -- NEED HELP
Total Quantity Picked (Pick Table)

I would appreciate your input & help on the same. 
Feel free to ping me private or add comments here if you need further informatino

Thank you
Regards,
Aakash Majethia

[Anonymous · Accepted solution]

Hi @Anonymous 

Please download my pbix file to see the details. Hope it will be helpful.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Anonymous]

I wanted to give a huge shoutout to @Anonymous  for your absolutely incredible, unwavering, and selfless support. Your timely and invaluable assistance with something I was struggling with the most has been beyond amazing. I am profoundly grateful and endlessly appreciative of your thoughtful, kind-hearted, and diligent efforts.

Your exceptional generosity, patience, and resourcefulness have made an immense and lasting impact. I am deeply thankful for your relentless dedication and the countless ways you have gone above and beyond to help me. Truly, your support has been a game-changer, and I cannot express my gratitude enough.

Thank you so much once again. Your kindness and expertise are greatly appreciated!

[Anonymous]

I'm glad my solution helps. You are very welcome!

[Anonymous]

@dufoq3  @Bibendum @AlienSx  Appreciate if you could help me please