Getting Maximum date selected from date column

Question

Hi everyone, i'm trying to get the latest date selected in a new columnmy data is structured like;&nbsp;Employee_name | Hire date&nbsp; &nbsp; | Latest dateWittig Lyon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;1/1/2023&nbsp; |&nbsp;Wittig Lyon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;5/4/2023&nbsp; |Wittig Lyon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;9/8/2023&nbsp; |&nbsp; 9/8/2023Henry&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;31/1/2023&nbsp; |&nbsp;Henry&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;12/9/2023&nbsp; |&nbsp; 12/9/2023Henry&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;1/9/2023&nbsp; |&nbsp;&nbsp;i`d love to have the Latest date be populated with the latest date of each employee thereby having 9/8/2023 as the value populating the latest date column for Wittig Lyon and 12/9/2023 for Henry&nbsp;

amitchandak · Accepted Answer

WittigLyon , for a new column 
&nbsp;
New col=
var _max = maxx(filter(Table, [Employee_name] = earlier([Employee_name]) ), [Hire Date])
return
if( [Hire_date] = _Max, [Hire_date], blank())
&nbsp;
For measure use
Latest https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e
&nbsp;
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

Forum Discussion

Getting Maximum date selected from date column

2 Replies

Related content

Running Maximum

Show maximum Yearmonth Value selected in the Dropdown.

Rows - Maximum Date

Getting the Maximum number across multiple columns

Get Maximum Value Text