recursive calculation

Alphacom Recrusive calculations are generally a problem and can't be done. However, this looks more like a calculated column that leverages a previous value. I am not certain though how you know you used 5 stock_qty. Bit confused by the data. But here is a general solution.

See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
 ( __Current - __Previous ) * 1.

Hi Alphacom ,

Thank you Greg_Deckler  for your prompt reply. I have created a sample data for you to help you with your problem. You can follow the steps below:

1.Add a new column.

Daily Stock Requirement = 
VAR _date = 'Table'[date]
VAR _product = 'Table'[product]
VAR CumulativeOrder =
    CALCULATE (
        SUM ( 'Table'[order_qty] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[date] <= _date
                && 'Table'[product] = _product
        )
    )
VAR CumulativeForniture =
    CALCULATE (
        SUM ( 'Table'[forniture_qty] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[date] <= _date
                && 'Table'[product] = _product
        )
    )
RETURN
    CumulativeOrder - CumulativeForniture - 'Table'[stock_qty]

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.