Forum Discussion
DAX calculation
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
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])))
2 Replies
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 - RequestsUpToDateWhere :
[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 HafizHello,
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])))
