NgautiFrequent Visitor1 year agoSolvedHow to add previous balance can anyone solve me for this, how to achieve balance using dax Show MoreDeelip1 year agoHi Ngauti Use the below dax to get the balance output Balance = VAR cydate = MAX('Table'[Date])VAR PreviousBalance = CALCULATE( SUM('Table'[Received]) - SUM('Table'[Processed]), 'Table'[Date] <= cydate )RETURN PreviousBalance
Deelip1 year agoHi Ngauti Use the below dax to get the balance output Balance = VAR cydate = MAX('Table'[Date])VAR PreviousBalance = CALCULATE( SUM('Table'[Received]) - SUM('Table'[Processed]), 'Table'[Date] <= cydate )RETURN PreviousBalance
Deelip1 year agoHi Ngauti Use the below dax to get the balance output Balance = VAR cydate = MAX('Table'[Date])VAR PreviousBalance = CALCULATE( SUM('Table'[Received]) - SUM('Table'[Processed]), 'Table'[Date] <= cydate )RETURN PreviousBalance
DeelipResolver I1 year agoHi Ngauti Use the below dax to get the balance output Balance = VAR cydate = MAX('Table'[Date])VAR PreviousBalance = CALCULATE( SUM('Table'[Received]) - SUM('Table'[Processed]), 'Table'[Date] <= cydate )RETURN PreviousBalance
Related contentPrevious Day Balance - Excluding WeekendsInventory and Stock balance calculationRemaining Balance Depends on Prior Monthbalance from previous quarterRunning Balance and Adding Previous Month Balance
