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