Forum Discussion

Dee's avatar
Dee
Icon for Helper III rankHelper III
6 years ago

How to find second latest date after max date

Hi all, I am trying to find the second latest date after the MAX date. orderdate 2019-12-11 2019-12-31 2019-12-31 This is what I have tried but doesn't seem to work. ``` calcul...
Need Help
Tutorial Requests
Dee's avatar
Dee
Icon for Helper III rankHelper III
6 years ago

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 have

A 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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dee  - Could you share our pbix file?

  • Dee's avatar
    Dee
    Icon for Helper III rankHelper III
    6 years ago

    I seem to not have the option for uploading.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Dee  - You'll need to upload it to OneDrive / Dropbox or some other file sharing site and then share the link. Careful not to include any sensitive data.