ORDERBY and SELECT with 2 items to be filtered

I need to sort and filter rows at the same time. I have 2 items to filter out:
[Milestone] “13 Closed”
[Milestone] "14 Funded

The expression below works fine, I just need to add the 2nd item and dont know how

Current expression
ORDERBY(SELECT(customers[ID],[Milestone]<>“13 Closed”),[Customer],FALSE)

Please help :slight_smile:
Thanks

Hi @teamMedina
Check out AND()

2 Likes

Yes, what @Lynn said … you can use AND() to combine filtering criteria in the SELECT() function

2 Likes

Where do I write the AND?
ORDERBY(SELECT(customers[ID],[Milestone]<>“13 Closed”),[Customer],FALSE)

In the SELECT(). It would look like this:

ORDERBY(SELECT(customers[ID], 

               AND([Milestone]<>“13 Closed”, [Milestone]<>“14 Funded”)),

        [Customer],FALSE)
1 Like

Naiiiiissss… it worked. Thank you Lynn and John for taking the time … Enjoy the holiday weekend

Cheers
TM

4 Likes

@teamMedina
Good work!

1 Like