Create a new report

[santu1021]

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

[Nathaniel_C]

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

[santu1021]

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_C]

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

[santu1021]

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

[Nathaniel_C]

is the blank 0

[santu1021]

Yes,  0 is no stock at ware house

[Nathaniel_C]

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