Hello,
I have a Category Table and a Projects Table.
The Projects table has a column named Project Category, which references the Category Table.
There are three rows in the Category Table and so in the Form of a project, the Project Category Dropdown displays these three values.
How can I make this dropdown display only two of these values? without erasing the row from the Category Table itself.
I tried putting this in the Valid if of the Projects Category column but it doesn’t work…:
[Project Category]<>“ValueNotWanted”
Thank you,
Sorin
Solved! Go to Solution.
@sorin_mihai
Valid_if
SELECT(Projects[Key], NOT([Project Category]=“ValueNotWanted”))
@sorin_mihai
Valid_if
SELECT(Projects[Key], NOT([Project Category]=“ValueNotWanted”))
Thank you
You’re very welcome
@sorin_mihai
Also provided the unwanted value in not falling into the middle when you sort that column in ascending or descending order, you can also use one of these:
TOP(
ORDERBY(
SELECT(Projects[Key],TRUE,TRUE), //cosntruct the list
[Project Category], //as per this column
FALSE //sort in ascending order
),
2 //return top 2 values
)
OR
TOP(
ORDERBY(
SELECT(Projects[Key],TRUE,TRUE), //construct the list
[Project Category], //as per this column
TRUE //sort in descending order
),
2 //return top 2 values
)
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |