Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
Hi @WittigLyon
Add calculated column with the formula :
@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
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
60 | |
57 |