I am looking for help with a DAX Measure. I have a list of milestones that might change each month. I am looking to do two things.
- Return the latest status value of the milestone,
- Count the number that match that status value, e.g.how many are now Green, Amber, etc.
My data looks a...