Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
bradytb
Regular Visitor

Three columns on one table, need to return the earliest

I have one table that is being used (Pro Staff Info)

I have three separate columns that include a date or an N/A.

 

Pro Staff Info

Columns:

Initial Cert Exp (there is a date in this column if they have this type of cert, N/A if they don't)

Conditional Cert Exp (there is a date in this column if they have this type of cert, N/A if they don't)

Continuing Cert Exp( there is a date in this column if they have this type of cert, N/A if they don't)

 

I need a way to compare these columns and return the earliest date of the 3 columns.  

The staff can have more than one type of cert to expire.  

 

Ex: Sally has an initial cert expiring 6/30/2025 and a conditional cert expiring 6/30/2026.  I would need a column that just returns the earliest date (in this example  6/30/2025).  

 

The purpose is for the admin assistants to know when someone is expiring and starting the process to recertify.   

1 ACCEPTED SOLUTION
v-jialongy-msft
Community Support
Community Support

Hi @bradytb 

 

Based on your needs, I have created the following table.

vjialongymsft_0-1720580709940.png

 

Then you can use the following dax to get the result you want:

Measure = VAR select_name = SELECTEDVALUE('Pro Staff Info'[Name])
RETURN
MINX(FILTER(ALL('Pro Staff Info'),'Pro Staff Info'[Name]=select_name && 'Pro Staff Info'[Date]<>BLANK()),'Pro Staff Info'[Date])

 

 

Result:

vjialongymsft_1-1720580762251.png

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-jialongy-msft
Community Support
Community Support

Hi @bradytb 

 

Based on your needs, I have created the following table.

vjialongymsft_0-1720580709940.png

 

Then you can use the following dax to get the result you want:

Measure = VAR select_name = SELECTEDVALUE('Pro Staff Info'[Name])
RETURN
MINX(FILTER(ALL('Pro Staff Info'),'Pro Staff Info'[Name]=select_name && 'Pro Staff Info'[Date]<>BLANK()),'Pro Staff Info'[Date])

 

 

Result:

vjialongymsft_1-1720580762251.png

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.