Cannot compare List with Text

[HYSSOTEC]

ME PUEDEN AYUDAR A SOLCUONAR EL SIGUIENTE ERROR.

QUIERO MOSTRAR LAS HABITACIONES CON ESTADO DE LIBRE.

thanks

[dbaum]

SELECT not IN

[Sirfyaad]

CONTAINS(HABITACIONES[NOMBRE], "LIBRE")

In this example, HABITACIONES[NOMBRE] represents the list of names from the HABITACIONES table, and "LIBRE" is the text value you want to compare against. The CONTAINS() function will return true if any of the names in the list contain the text "LIBRE".

Make sure to adjust the table and column names according to your specific data structure.

IN([NOMBRE], SELECT(HABITACIONES[HABITACIONES], [ESTADO] = "LIBRE"))