How to get a table with lastest stage from each name based in date?

[AlexFelipe]

I wanna show in table only the lastest stage from each name based in date.

I tried use MAXX function but i failed.

How can i make it? Thanks everyone

[tamerj1]

Hi @AlexFelipe 

is the Date column form the same table or from a date table?

[AlexFelipe]

From the same table

[themistoklis · Accepted solution]

@AlexFelipe 

Please create a new measure and add the following formula:

MaxStage = CALCULATE(MAX(Sheet1[Stage]),FILTER(Sheet1,Sheet1[Date]=MAX(Sheet1[Date])))

PowerBI workspace attached

[AlexFelipe]

Works! Thank you so much!!

I'll just leave the code here for everyone:

MaxDate = CALCULATE(MAX(Sheet1[Date]),FILTER(Sheet1,Sheet1[Date]=MAX(Sheet1[Date])))

MaxStage = CALCULATE(MAX(Sheet1[Stage]),FILTER(Sheet1,Sheet1[Date]=MAX(Sheet1[Date])))