Forum Discussion

sandyn-2303's avatar
sandyn-2303
Frequent Visitor
2 years ago
Solved

Calculating difference between Inventory for current month and forecast for next months

Hello,   I need help with creating a table like below. It need to get remaining stock in inventory every month till it goes negative. I have given the example below. If current month is August, I t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sandyn-2303 ,

    Please try to create a new column with below dax formula:

     

    Remaining Stock =
VAR _inventory =
    MAXX ( 'Table', [Inventory] )
VAR _date = [Date]
VAR tmp =
    FILTER ( 'Table', [Date] <= _date )
VAR _a =
    SUMX ( tmp, [Forecast Sale] )
RETURN
    _inventory - _a

     

    Please refer the attached .pbix file

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sandyn-2303 ,

Please try to create a new column with below dax formula:

 

Remaining Stock =
VAR _inventory =
    MAXX ( 'Table', [Inventory] )
VAR _date = [Date]
VAR tmp =
    FILTER ( 'Table', [Date] <= _date )
VAR _a =
    SUMX ( tmp, [Forecast Sale] )
RETURN
    _inventory - _a

 

Please refer the attached .pbix file

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.