Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would like to create a new report, I have around 1 billions part numbers. For these part numbers, on daily basis, I would like to have a report which gives stock level as below.
Warehouse1 Stock | Warehouse2 Stock | |
SKU 1 | No Stock | No Stock |
SKU 2 | No Stock | In Stock |
SKU 3 | In Stock | No Stock |
*Ignore if stock on both warehouses |
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
Proud to be a Super User!
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
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
Proud to be a Super User!
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
Proud to be a Super User!
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |