Forum Discussion

joep78's avatar
joep78
Icon for Helper III rankHelper 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

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi joep78 ,

If you use FILTER('Table','Table'[Contract end date] = MAX('Table'[Contract end date])) , the result is from the highest contract end date. How do you calculate it? Can you please share your formulas and show the expected results?  Then we will understand clearly and solve it quickly.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.