Report last date for each employee

[Riggs1440]

I have a file that gets updated regularly with information from a number of employee records.  I would like to add the last date the file was updated to my report. 

Here is a sample of data

Name   Date                   Data

John     June 1, 2019       121

John     June 2, 2019       200

John     June 3, 2019       161

Chris    May 10, 2019      231

Chris   May 11, 2019      141

Steve   May 24, 2019     161

I would like to generate a visual that provides the latest date for each employee.

This way we can see anyone that is failing to update their file in a timely manner.

[v-yuta-msft · Accepted solution]

@Riggs1440 ,

You can create a measure using DAX below:

Last Date Per Name = CALCULATE(MAX('Table'[Date]), ALLEXCEPT('Table', 'Table'[Name]))

 

Community Support Team _ Jimmy Tao

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

[danno]

Use a Measure with the MAX function over the date column i.e last date = MAX(Date), then split the report visual by person and it will show just the last date for each person