cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Sort Matrix based on latest Column Date per Record

I'm trying to use a Matrix to show all of the items in my database that are expiring based on the person it is tied to - I also want it to show the other records for that person like in the image below.

pbi-help-matrixSorting.gif

To be clear, my table has 1 or 2 records (certifications) per person.  One of the certifications is called "Privileges" and the other is optional but the person might also have one called "Provisional".  This matrix finds both of each person's certifications and shows them side-by-side with the person.

pbi-help-matrixSorting2.PNG

I have it sorted by date but it's only sorting by certifications that are "Privileges" and not certifications that are "Provisional".  I want it to find the earliest date between the "Privileges" and "Provisional" and sort the entire table based on the earliest of the two from newest date to oldest date.

I can't figure out how to do this.  Can anyone help?

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Sort Matrix based on latest Column Date per Record

Hi @mdslater ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors