Forum Discussion
Helper IIIHow to find second latest date after max date
Dee - Is the column a Date/Time column? If so, this could be problematic. You can convert it to a date column in Power Query.
Helper IIII understand now, this only brings out one date, I should have phrased my question better, supposedly I have a column with different dates for different users how do I return second dates for them all?
The formula is actually correct for getting the max date(for anyone looking for just one) how do I get it in a column
Dee - If you create a Table Visual, and add People and this Measure, it should calculate the Measure for each People. The idea is that each Person is a filter which limits the data, and the Measure is calculated within that context.
- Dee
Hi, Anonymous thank you for the response, I've actually tried but it ends up filling in the same date for all,
let me explain a bit more
supposedly I haveA 3.2.2019
A.2.2.2019
B.4.2.2019
B.1.2.2019
C.5.2.2019
C2.2.2019
For max of each, I would get 3.2.2019,4.2.2019,5.2.2019
How do I bring the second one now out individually for each, cause what the formula I have, is returning the max of them all which is 5.2.2019 and returning 4.2.2019 as the second max, not sure if I have explained exactly what I need?
I would be grateful for your help.
Dee - Could you share our pbix file?