I have a dropdown menu using the Valid if con...

(Ellen Sligh) #1

I have a dropdown menu using the Valid if constraint from another table.

The dropdown is a Valid if: Monday[Monday Dates]

Column Type is Date.

I want to filter the valid if one more step.

I want only the Monday Dates = today and greater to show and not to show the dates less than today.

How can I further filter or constrain this dropdown?

(Aleksi Alkio) #2

SELECT(Monday[Monday Dates],[Monday Dates]>=TODAY())

(Ellen Sligh) #3

As a ‘select’ expression - would that mean it must be a virtual column and be a LIST column type?

(Aleksi Alkio) #4

No… you can use that in Valid_If

(Ellen Sligh) #5

excellent!!!

(Ellen Sligh) #6

so this worked well - do you know if it is possible to use this type of constraint with more than one condition?

(Aleksi Alkio) #7

Yes you can do that. For example SELECT(Monday[Monday Dates],AND([Monday Dates]>=TODAY(),[Monday Dates]<TODAY()))