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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try like

calculate(count([Syscode]),filter(all(table),table[Contract end date]=max(table[Contract end date])))

 

prefer to join Contract end date with the date of date dimension and try

 

calculate(count([Syscode]),filter(all(date),date[date]=max(date[date])))

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin