Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
Anonymous
Not applicable

undefined

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

I have 3 different tables in power BI: 

Aakash_Majethia_1-1716996519578.png


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 

Aakash_Majethia_2-1716996594994.png


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)


Aakash_Majethia_3-1716997244017.png



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





1 ACCEPTED SOLUTION
v-jingzhan-msft
Community Support
Community Support

Hi @Anonymous 

 

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

vjingzhanmsft_0-1717062664634.png

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

View solution in original post

4 REPLIES 4
v-jingzhan-msft
Community Support
Community Support

Hi @Anonymous 

 

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

vjingzhanmsft_0-1717062664634.png

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

Anonymous
Not applicable

I wanted to give a huge shoutout to @v-jingzhan-msft  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!

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.