Getting Calculated column with Total Daily Balance from several transactions on same day same table

[Jnickson49]

I am trying to create a calculated Column that provides me with the daily end balance for that day as shown below but struggling with the dax that would do something like this any ideas are much appreciated, thanks.

Date	Transaction	Balance After each transaction	Index
1st Aug	-50	500	1
1st Aug	-20	480	2
1st Aug	-60	420	3
3rd Aug	-60	360	4
6rd Aug	-100	260	5

Date	Transaction	Balance After each transaction	Index	Daily Balance
1st Aug	-50	500	1
1st Aug	-20	480	2
1st Aug	-60	420	3	420
3rd Aug	-60	360	4	360
6rd Aug	-100	260	5	260

[Greg_Deckler · Accepted solution]

@Jnickson49 Try:

Daily Balance Column =
  VAR __Date = [Date]
  VAR __Index = [Index]
  VAR __MaxIndex = MAXX(FILTER('Table',[Date] = __Date),[Index])
RETURN
  IF(__Index = __MaxIndex, [Balance After each transaction],BLANK())