Dividing rows to get pallet qty

[olivere91]

Hello,

I have my inventory in one column, how can I create a column that divides the inventory column by a number to get pallet count?

I have multiple pallet configurations depending on the SKU. The good news is, SKU 12345 will always be in pallet configurations of 100.

Thanks for your help. 

[AllisonKennedy · Accepted solution]

@olivere91  Do you have a table of SKU and denominator? IE: 

SKU	Pallet Config Value
12345	100
12346	60

It can be a column added in your DimProduct table.

Then assuming your Inventory table is related by 1 to many on SKU to the DimProduct table, you could use new column: 

Pallet Count = DIVIDE( Inventory[Value] , RELATED( DimProduct[Pallet Config Value]) )

[olivere91]

Thank you for your help!

[AllisonKennedy]

You're welcome. Glad it worked.