Get value of column based on lastest date

[kattlees]

I have a column with AcctNum, Insurance, Date, Status, Paid Date

Entries may look like this

123456        CB          12-14-18              PAID                   2-14-18
123456        MPA       1-16-18               REJECTED            2-16-18

123456        MBI        2-16-18               BILLED         

654321        CPA       1-15-18                BILLED

654321        CB          1-15-18               BILLED

I need to get the Insurance Value from the last entry

So for 123456, I would need to get MBI 

For 654321 I would get CB

[vega]

I think you would have to add some sort of index that increases incrementally as you add entries. I don't believe DAX has a way to access the entry order of records. 

[kattlees]

If I add an index column, what would it take to get the latest one?

[vega · Accepted solution]

If you add an index column and you data looks like the following:

Then to get the results you desire, then use the following formula:

Measure = 
CALCULATE(
    MAX(Table1[Insurance]),
    FILTER(Table1,Table1[Index] = MAX(Table1[Index]))
)

And you will get the correct results: