Hello,
I'm having an issue where I'm trying to locate the latest or "Max" date in each row and find the date diff to a different date. I'll try to explain and I've attached the example workbook as well
Here I have a list of dates. Here we have a start, BA, Chair, Legal, and Finance approval dates.
The BA, Chair, and Legal Approval process all start on the Exact same time as the start date. The Finance Approval process can't begin until the last of these 3 processes finish.. So for project 1A.. The finance Approval wouldn't be able to start until the 4/2/2017 as the Chair Approval was the last to finish out of the 3 that started at the same time
PROBLEM: I'm trying to find the difference of the Finance Approval Date to the the Approval Process that finished last out of BA, Chair, and Legal
This snapshot is taken from tableau. I've created 3 calcs finding the date diff of BA, Chair, and legal to the Start date so we can easily which process took the longest, and there fore is the latest or max of the 3.
Let me know if this doesn't make sense and i can clarify it better.
Thank you.
