Hi there!
Any ides in how can I filter the values in a Ref column depending if a condition is true or false in the table that is been Ref?
Eg: I had a table that has Cars information, model, company, year etc…
In other table the table that has the Ref column shows the cars names. I need to filter this Ref column if the car model is between year 1970 and 1980. Is there a way to do this?
Thanks! Apa
Great! I will try and let you know
An expression like this in the Ref column’s Valid_if should do the job:
FILTER(Cars, AND([Model]>=1970,[Model]<=1980))
I deleted my first comment and posted another one right after yours!
Many thanks Reza!
You are welcome Apa.
Another question! I had another table that I enter specific diferent type of leather seat canvas (as unique ID) where each one of this are Ref to a specific car.
Getting back to the previews table (the one that has the Ref valid if formula) how can I filter other column to select the seats that belong to the car?
I think I solve it:
=IN( [_THIS], SELECT(Canvas seats[UID], [_THISROW].[Car] = [Car]))
But how can I also filter depending on the type of canvas? Show be somthing like this:
AND(=IN( [_THIS], SELECT(Ficha Familiar[UID], [_THISROW].[SIPI] = [Alumno]), IF([Canvas])=“xx”,true,true))
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |