Summarize by max date

[PowerBITestingG]

I have been looking around the forum but I cant seem to figure it out

I have this table:

Name	Lastdate
Microsoft	04/01/2017
Microsoft	03/01/2018

And I want to create this table:

Name	LastDate
Microsoft	03/01/2018

I am using summarize(table, name, "max",max(date)) but somehow I am getting 04/01/2017. 

Its probably something obvious but I would appreciate your help

[lukiz84 · Accepted solution]

Is "LastDate" formatted as text or as Date? There should be the problem 😉

Format it as Date ... 

[PowerBITestingG]

Yep that was it, thank you!