Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with these columns:
Name and Date Obs
I want to add a third column (Latest Obs Date). Latest Obs Date looks at all rows with the same Name, finds the latest Date out of all those rows, and gives me the date from that row. See example in the table below:
Name | Date Obs | Latest Obs Date |
Abraham Lincoln | 8/1/2019 | 8/1/2019 |
Bill Gates | 8/5/2019 | 9/2/2019 |
Bill Gates | 9/2/2019 | 9/2/2019 |
Gandhi | 8/9/2019 | 9/3/2019 |
Gandhi | 9/3/2019 | 9/3/2019 |
John F. Kennedy | 9/2/2019 | 9/2/2019 |
John F. Kennedy | 8/14/2019 | 9/2/2019 |
Marilyn Monroe | 9/11/2019 | 9/11/2019 |
Thanks in advance for the help
Solved! Go to Solution.
Check
https://community.powerbi.com/t5/Desktop/How-to-find-latest-date-value-in-a-group/td-p/379104
https://community.powerbi.com/t5/Desktop/Return-Latest-Date/td-p/417291
Check
https://community.powerbi.com/t5/Desktop/How-to-find-latest-date-value-in-a-group/td-p/379104
https://community.powerbi.com/t5/Desktop/Return-Latest-Date/td-p/417291
Thanks @amitchandak,
I'm working with tables that I need to join based on this calculated field. I know how to do the calculation in DAX, however, this doesn't help me merge the tables (I need to join on multiple columns so relationships won't work). I know if I can get the DAX function I used in DAX into Power Query I will be able to merge the tables but I just can't quite get the formula right. This is what I have in DAX:
Latest Obs Date = CALCULATE ( LASTDATE ( 'Tutor Observation Log'[Date Obs] ), ALLEXCEPT ( 'Tutor Observation Log' , 'Tutor Observation Log'[Name] ) )
Any help is appreciated!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |