Forum Discussion
Create a new report
Hi santu1021 ,
If I understand your question, your measure would be. Replace table with your table name, and W1 Stock with your column name. Dropping these two measures on the table next to the SKU will filter for each SKU #
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
Warehouse1 Stock =
var _total =SUM(table[W1 Stock)
var _calc = IF(_total>0,"In Stock", "No Stock")
return _calc
Warehouse2 Stock =
var _total =SUM(table[W2 Stock)
var _calc = IF(_total>0,"In Stock", "No Stock")
return _calc
- santu10216 years agoHelper II
Hi Nathaniel,
Thank You for the reply
My data is in below template.
Org Code : are warehouse 1 and warehouse 2
CPN : are part numbers
Total On Hand qty : Stock
I'm tried the setups you have mentioned but bit lost with it.
May I ask to provide more details with steps, screen shots
- Nathaniel_C6 years agoCommunity Champion
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
- santu10216 years agoHelper II
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