Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Max Date for Employee Column

I have the following table:   Date Emp ID 1/2/2019 325 1/3/2019 326 1/4/2019 325 1/5/2019 326 1/7/2019 401 1/8/2019 401   I'd like to get the result: Emp ID Ma...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    7 years ago

    Hi Anonymous ,

     

    I think you might have created a column instead of a measure.

    In my answer, I created a measure.

    The result will be wrong if you created a calculated column.

     

    Best Regards,

    Eads

     

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

v-eachen-msft's avatar
v-eachen-msft
Community Support
7 years ago

Hi Anonymous ,

 

You just need a measure to use MAX() function.

Max Date =
MAX ( test[Date] )

Then you can use a table visual to get result.


Don’t summarize the value of Emp ID.

Best Regards,

Eads

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I wish it was that easy. When I tried that I got the max date for the entire column, not the one for the employee column. In sql I would have done something like, max([date] for [employee])

    • v-eachen-msft's avatar
      v-eachen-msft
      Community Support
      7 years ago

      Hi Anonymous ,

       

      I think you might have created a column instead of a measure.

      In my answer, I created a measure.

      The result will be wrong if you created a calculated column.

       

      Best Regards,

      Eads

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        You are right! Thank you!