HELLO, IM WORKING ON AN INVENTORY APP, I AM NEW ABOUT USING FORMULAS
WHAT I WANT IS A FORMULA THAT GETS THE STOCK OF EVERY ITEM
FOR EXAMPLE
ITEM 01 HAS 5 PRODUCTS
ITEM 02 HAS 3 PRODUCTS
WHAT I WANT IS THAT THE QUANTITY OF PRODUCTS APPEARS, I TRIED USING TOTAL STOCK AVAILABLE BUT THAT FORMULA SUMS ALL THE AMOUNT PRODUCTS AND NOT BY ITEM ID
It gives total amount Because you are adding (sum) Amount. You expression is wrong.
BTW where is the column [Quantity] in the table?
Sum (
Select ( inventory [Quantity] …
sorry is not quantity, is the column amount
So i need to create a column Quantity in the table
and use this expression? SUM(
SELECT(Inventory[Quantity], ([Item ID] = [_THISROW].[Item ID]))
)
1 Like