DAX calculation

[Michael92]

Hello all,
I need to calculate the Stock - Request difference in the Matrix table. I always see only 3 days, yesterday, today and tomorrow. I need to calculate the current stock situation. I need to count requests and subtract it from the current situation in stock. For example, for Material M001... for 12.11.2024 it will be 80-60 =20,

for 13.11.2024 it will be 60+100-80 = -80

for 14.11.2024 it will be 60+100+20-80 = -100.
Is it possible to do this calculation in DAX and use it in matrix?

Thank you

[shafiz_p]

Hi @Michael92  Try below code:

Diff = 
VAR CurrentDate = MAX('Table'[Date])
VAR StockOnDate = 
    CALCULATE(
        [Stock'],
        'Table'[Date] = CurrentDate
    )
VAR RequestsUpToDate = 
    CALCULATE(
        [Request'],
        'Table'[Date] <= CurrentDate
    )
RETURN
    StockOnDate - RequestsUpToDate

Where :

[Stock'] = SUM('Table'[Stock])
[Request'] = SUM('Table'[Request])

Output:

Considering Dataset:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[Michael92 · Accepted solution]

Hello,

thanks for your feedback. It gave me zero values ​​everywhere.

But meanwhile i found a solution. This works for me:

Difference =

    CALCULATE(

SUM('Table'[Stock]) - SUM('Table'[Request]),FILTER(ALL(Date_table), Date_table[Date]<= MAX(Date_table[Date])))