Forum Discussion
Power Query Max Date for Multiple User IDs
Hello all, I am looking for help for what was a very easy thing to deliver as a custom column using a simple MAX statement. Here is some test data. Essentially I need to figure out how to build t...
Duplicate the table.
Perform a 'Group By' on ID with Max (Effective Date)
----
Use Merge Queries to join the resulting table with the original table ( joining on ID)
Appreciate the answer! For those looking, I was able to do this another way via measures and custom columns. Note: the tables are linked on associate ID.
1. Create a measure for max date from one table:
Test MaxDate = MAX('active'[Report Effective Date])
2. Using a custom column on the termianted table, create a new column, and point it to the new measure:
MaxDateValidation = [Test MaxDate]
This pulled in the maximum that the associate ID appeared on my active table. I was then able to do a simple IF custom column to detect if an associate was a rehire or not.