Forum Discussion
Solved
Getting Maximum date selected from date column
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 ...
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-d0cf2fcf92d0Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
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())If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Ritaf1983
Super User
Super UserHi 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())
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.