Need help with DAX

Hi heygau ,

Thanks for Musadev  sharing. Please refer to my steps have a try.

Stock on Hand =
VAR OpeningBalance = 27192
VAR CumulativeReceivals =
    CALCULATE (
        SUM ( Receivals[Quantity] ),
        FILTER ( ALL ( 'DateTable' ), 'DateTable'[Date] <= MAX ( 'DateTable'[Date] ) )
    )
VAR CumulativeSales =
    CALCULATE (
        SUM ( Sales[Quantity] ),
        FILTER ( ALL ( 'DateTable' ), 'DateTable'[Date] <= MAX ( 'DateTable'[Date] ) )
    )
RETURN
    OpeningBalance + CumulativeReceivals - CumulativeSales

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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