Forum Discussion

nizaeros's avatar
nizaeros
New Member
4 years ago

Max function showing wrong. Need help for Powerbi Matrix total

Hello everyone, I need your support to solve and understand issues in my DAX. I have a transactionDB of all bank transaction like below:   date company type Source Bank amount 01-Apr-22 ...
matrix calculation
Matrix grouped columns issue
MAX date
amitchandak's avatar
amitchandak
Super User
4 years ago

nizaeros , with help from a date table you need measure like

 

[Intial Balance] + CALCULATE(SUM(Table[Credit]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Debit]),filter(date,date[date] <=maxx(date,date[date])))

Closing Bal =
[Intial Balance] + CALCULATE(SUM(Table[Credit]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Debit]),filter(date,date[date] <=maxx(date,date[date])))