Forum Discussion
Create a new report
Hi santu1021 ,
Just got online again. Would you copy and paste what you in that picture directly into this message. I will build a pbix with it and detail the steps.
Thanks,
Nathaniel
Warehouse 1 and 2 have common part numbers. I have over 1 billions lines and I need to run this daily report to take action.
scenario 1 : If same part number (ex part 1) is in stock at Both Warehouses : No action for me to take.
Scenario 2 : If same part number (ex part 2) is in stock at WH 1 and not in stock at WH2 : Action to take for me on WH2.
Scenario 2 : If same part number (ex part 3) is not in stock at WH 1 and is in stock at WH2 : Action to take for me on WH1.
Scenario 3 : If same part number (ex part 3) is not in stock at WH 1 and WH2 : Action to take for me on WH1 and WH2
| WareHouse 1 and 2 | Item No | Stock |
| Warehouse 2 | Part 1 | 7 |
| Warehouse 1 | Part 1 | 315 |
| Warehouse 2 | Part 2 | |
| Warehouse 1 | Part 2 | 100 |
| Warehouse 2 | Part 3 | 50 |
| Warehouse 1 | Part 3 | 0 |
| Warehouse 1 | Part 4 | 0 |
| Warehouse 2 | Part 4 | 0 |
is the blank 0
Yes, 0 is no stock at ware house
Hi santu1021 ,
Here is my PBIX
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel