How to select values based on max index inside groups

[johndoe293]

Hello,

I'm stuck trying to build both a table and a line chart where the data is grouped by day, month, and year and the table needs to show the balance of the last index by groups.

This is the dataset. Each date has multiple index values and I need to select the Balance of the highest index, based on date.  This will be used as input in a line chart to plot ending balance of the day.

I've played around with SUMX, TOPN, and MAXX  but can't seem to cross reference correctly.

[johndoe293 · Accepted solution]

Moments after posting I managed to figure it out...

New Measure:
Last Balance = SUMX(TOPN(1,Table, Table[Index], DESC), Journal[Balance])