Getting Maximum date selected from date column

[WittigLyon]

Hi everyone, i'm trying to get the latest date selected in a new column

my data is structured like;

Employee_name | Hire date    | Latest date

Wittig Lyon         |   1/1/2023  | 

Wittig Lyon         |   5/4/2023  |

Wittig Lyon         |   9/8/2023  |  9/8/2023

Henry                 |   31/1/2023  | 

Henry                 |   12/9/2023  |  12/9/2023

Henry                 |   1/9/2023  | 

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 

[amitchandak · Accepted solution]

@WittigLyon , for a new column

New col=

var _max = maxx(filter(Table, [Employee_name] = earlier([Employee_name]) ), [Hire Date])

return

if( [Hire_date] = _Max, [Hire_date], blank())

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-f1c839ee8...

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

[Ritaf1983 · Accepted solution]

Hi @WittigLyon 

Add calculated column with the formula :

last date = if('Table'[ Hire date    ]=CALCULATE(max('Table'[ Hire date    ]),ALLEXCEPT('Table','Table'[Employee_name ])),[ Hire date    ],blank())

Link to a sample file 

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

[amitchandak · Accepted solution]

@WittigLyon , for a new column

New col=

var _max = maxx(filter(Table, [Employee_name] = earlier([Employee_name]) ), [Hire Date])

return

if( [Hire_date] = _Max, [Hire_date], blank())

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-f1c839ee8...

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8