Forum Discussion
Cipriano
Helper III
Helper IIIHow to calculate inventory?
Hello, everyone, It is necessary for me to perform the inventory calculation using the attached data set, but I do not know how to implement the second recursive DAX formula that uses the previou...
See a solution in the other thread you posted:
https://community.powerbi.com/t5/Desktop/Como-calcular-el-inventario/m-p/2714090#M948254
tamerj1
Community Champion
Community ChampionHi Cipriano
If your date column has only unique values then you do
Stock =
VAR CurrentDate = TableName[Date]
VAR OnAndBeforeTable =
FILTER ( TableName, TableName[Date] <= CurrentDate )
RETURN
SUMX ( OnAndBeforeTable, TableName[IN] - TableName[OUT] )
CiprianoHelper III
Helper IIII appreciate you, but it has different values.