Latest date dax

[Malps90]

Hi, 

I am having some issues trying to build a new measure. 

What I am trying to achieve is;

I have a list if employees with there review dates and when review was completed. I am trying to build a measure that will show me only the latest review date rather than all review dates for that employee code The data is completed by power apps and feeds Into a sharepoint list.

I tried to create an index column flip it and remove duplicates so it only leaves me the latest line per employee but this didnt quiet work

Any help would be appreciated.

Many thanks

[Anonymous · Accepted solution]

// This measure will find the latest
// review date in a set of Employees.
// If one employee is visible, it'll
// return the very latest review date
// for this employee.
// If you have a Review Calendar that
// connects to Employees via the Review
// Date field, you'll get the latest
// review date within the selected period
// of time. It's not clear exactly what
// you really want to do and what your
// model looks like.
[Latest Review Date] =
	MAXX(
		Employees,
		Employees[Review Date]
	)

Best

D

[Greg_Deckler]

Sample data would assist greatly. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But perhaps this will help: 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814