NgautiFrequent Visitor1 year agoSolvedHow to add previous balancecan anyone solve me for this, how to achieve balance using daxDeelip1 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
2 RepliesReplies sorted by Most LikedDeelipResolver 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 NgautiFrequent Visitor1 year agoThanks so much
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
