Hi there! Any ides in how can I filter the v...

[Aparicio_Pineyr]

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

[Aparicio_Pineyr]

@RezaRaoofi

Great! I will try and let you know

[RezaRaoofi]

An expression like this in the Ref column’s Valid_if should do the job:

FILTER(Cars, AND([Model]>=1970,[Model]<=1980))

[RezaRaoofi]

I deleted my first comment and posted another one right after yours!

[Aparicio_Pineyr]

@RezaRaoofi

Many thanks Reza!

[RezaRaoofi]

You are welcome Apa.

[Aparicio_Pineyr]

@RezaRaoofi

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?

[Aparicio_Pineyr]

@RezaRaoofi

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))