How can I display the latest year on the third column for each customer

[ligalbert]

I want to only display the latest year of the third colum per every customer. For example for the first customer 501-1117 I want the second column to be 2011 and third column to be 2018 and thats all the info I would

[v-xiaotang]

Hi @ligalbert 

Have you solved this question with amitchandak's help? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@ligalbert , Based on what I got

New measure  =

maxx(filter(allselected(Table), Table[AcCustomerID] = max(Table[AcCustomerID])), Table[Year])