collumn dependency and stock movement and management

[MohTerki]

Hello everyone, 

I am working on a stock management and I want to evaluate final stock.

So I have collumns named "final stock", "entry", "outings".

I want to evaluate "final stock" which is previous "final stock" + same "entry" - same "outings".

Is it possible to make it in one collumn "final stock"? 

[johnt75 · Accepted solution]

You could create a measure like

Final stock =
VAR CurrentDate =
    MAX ( 'Date'[Date] )
VAR Result =
    CALCULATE (
        SUM ( 'Table'[Entry] ) - SUM ( 'Table'[Outings] ),
        'Date'[Date] <= CurrentDate
    )
RETURN
    Result

[johnt75 · Accepted solution]

You could create a measure like

Final stock =
VAR CurrentDate =
    MAX ( 'Date'[Date] )
VAR Result =
    CALCULATE (
        SUM ( 'Table'[Entry] ) - SUM ( 'Table'[Outings] ),
        'Date'[Date] <= CurrentDate
    )
RETURN
    Result

[MohTerki · Accepted solution]

It did work thank you, 

You need just to delete Max 

@johnt75