Forum Discussion

joep78's avatar
joep78
Helper III
6 years ago
Solved

MAX value date field

Hi all,   I'm looking for a solution to get the MAX value of a date field but based on another value of another column. hereby a snapshot of the table with only the relavant column:   Syscode ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Joe - 

     

    Is this what you are after (please see attached image). It is a matrix visual btw, and it has only the max date values you are after. It is a measure created and I used it in the matrix visual. If you confirm that is what you are after, I will be able to share the measure as well.

     

     

     

     

     

    Regards

    Eswar

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Joe - 

 

Is this what you are after (please see attached image). It is a matrix visual btw, and it has only the max date values you are after. It is a measure created and I used it in the matrix visual. If you confirm that is what you are after, I will be able to share the measure as well.

 

 

 

 

 

Regards

Eswar

 

joep78's avatar
joep78
Helper III
6 years ago

Hi Eswar,

 

I think this is the solution i'm looking for with the only diference that for contract 68 the max year should be  Friday 14 september 2029. 

 

IS it possible to share the meassure so i'm able to test this. thanks in advance for your reply.

 

regards, Joep