Forum Discussion
Solved
Min Value across Multiple Columns, based on Associated Columns
Setup: I have a situation where coaches manually populate check-ins and progressions against milestones for specific members. These are collected across multiple tabs (one for or each coach). The ...
You first need to make the data table looks like the following, you may check the steps in power query, just some duplicates and remove columns.
Then you should able to find the earliest date with a a measure, also change min to max to get the latest date.
Earliest = CALCULATE(MIN([Message Sent]),FILTER('Union Table',[Member]="AC"&&[Milestone]="Milestone 3" ))Latest = CALCULATE(MAX([Message Sent]),FILTER('Union Table',[Member]="AC"&&[Milestone]="Milestone 3" ))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Important to note - I have already combined all the data from all the coaches in a unified dataset (via union) on powerbi.