Showing results for 
Search instead for 
Did you mean: 
Not applicable

help with ordering information

Hi everyone, 


I am building a dashboard to track certification.  Each certificate has its own row and uniqe ID number.  The comonality is the course the certificates are registered against has a common id so you can tell all the certs for a specific course. The problem I have is that you can have a valid and an expiring certificate for the training, but if there is a valid certificate I don't want it to count the expiring certificate ( which it is currently doing).

So the combo's I want it to understand is:

If the course has:

Expired, expiring and valid certificate - it shows the valid cert only

Expiring and valid- it shows the valid cert only

expired and valid - it shows the valid cert only

Valid - it shows as valid

expiring and expired - it counts the expiring cert only

Expiring - shows as expiring

Expired - shows as expired ( of course :))

Can anyone help me work this out.. 





Community Support Team
Community Support Team

Re: help with ordering information

Hi @Anonymous ,


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 other members find it more quickly.
Not applicable

Re: help with ordering information

I'm sorry I can't uplod the data but perhaps I can explain a little more. 


Each person does hazard management training every two years. each time they complete it a certificate is recorded it issues a certificate. so a person could end with 5 certificates if they ahve been here ten years. What I want the system to do is only show me the most recent certifcate and forget all the rest? 

Each course and user has a unique idenitifier 






Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 362 members 3,905 guests
Please welcome our newest community members: