Forum Discussion
Create a new report
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 |
7 Replies
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.
NathanielWarehouse1 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 _calcHi 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
