Forum Discussion
Min Value across Multiple Columns, based on Associated Columns
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.
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.
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.
Thank you! I ended up restructuring the data from Wide -> Long via union, and then performing the calculation on the long table which made much more sense!
