Forum Discussion
EARLIER function in Power BI
Hi all, I am new to this, I would like the 'Current Balance' by each line by date (from earliest to latest) and instead of aggregation by dates (items in red is not what I wanted - I need individual ...
Anonymous
You can use the INDEX column to get the running current balanceCurrent Balance = SUMX( FILTER( Table7 , Table7[Index] <= EARLIER(Table7[Index] )), Table7[Amount] - Table7[Beginning Balance] )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
Anonymous
You can use the INDEX column to get the running current balance
Current Balance =
SUMX(
FILTER( Table7 , Table7[Index] <= EARLIER(Table7[Index] )),
Table7[Amount] - Table7[Beginning Balance]
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
Thanks for the tip! Yes, this works according to what I need after I sort my Index column in ascending order.