Forum Discussion
Solved
Creating BOM Availability
I'm trying to make a report for whether you can make a master part number or not, and then which sub-assemblies can be used. I'm connecting to a Business Central DB but that part doesn't really matte...
Hello,
Create these calculated columns:
Inventory Per Category Per Item = CALCULATE ( SUM ( 'Table'[Inventory] ), ALLEXCEPT ( 'Table', 'Table'[Common Item Number], 'Table'[Item_Category_Code] ) )Min Inventory in All Categories Per Item = CALCULATE ( MIN ( 'Table'[Inventory Per Category] ), ALLEXCEPT ( 'Table', 'Table'[Common Item Number] ) )BOM = //returns true if [Inventory Per Category] = [Min Inventory in All Categories Per Item] 'Table'[Inventory Per Category] = 'Table'[Min Inventory in All Categories Per Item]
I'm going to add to this (and I really think this should be simple and don't know why I'm having a hard time):
if (sum(Inventory in Category) = min(sum(inventory in Category of all category sums))
Is that clearer? Am i making it worse?
Hello,
Create these calculated columns:
Inventory Per Category Per Item =
CALCULATE (
SUM ( 'Table'[Inventory] ),
ALLEXCEPT ( 'Table', 'Table'[Common Item Number], 'Table'[Item_Category_Code] )
)Min Inventory in All Categories Per Item =
CALCULATE (
MIN ( 'Table'[Inventory Per Category] ),
ALLEXCEPT ( 'Table', 'Table'[Common Item Number] )
)BOM =
//returns true if [Inventory Per Category] = [Min Inventory in All Categories Per Item]
'Table'[Inventory Per Category] = 'Table'[Min Inventory in All Categories Per Item]
Thank you! It's late here and I've been working since early but it looks perfect! Many thanks. If I ever see you, I owe you a drink.