Forum Discussion

rgalvez's avatar
rgalvez
Frequent Visitor
4 years ago
Solved

Latest date by user, by course

Hi experts! I have a list of employees that have taken courses in different periods. Some employees have taken one course several times. This is an example of my list: Higlithed in yellow is ...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    rgalvez add a measure 

     

    Last Completed Date = MAX ( Table[Completed Date] )

    and use it in the visualization

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

     

parry2k's avatar
parry2k
Super User
4 years ago

rgalvez add a measure 

 

Last Completed Date = MAX ( Table[Completed Date] )

and use it in the visualization

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

rgalvez's avatar
rgalvez
Frequent Visitor
4 years ago

Hey!

Thanks for your help but unfortunately this approach only gives me the latest date in all the column and not  the aggregation by EmployeeID and by CourseID, as the outcome is expected.

Or am I misinterpreting your solution?

 

Have a great day!