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

[Ellen_Sligh]

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]

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

[Ellen_Sligh]

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

[Aleksi_Alkio]

No… you can use that in Valid_If

[Ellen_Sligh]

excellent!!!

[Ellen_Sligh]

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

[Aleksi_Alkio]

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