Cant get IN function to work

[adambc]

Hello, I have this Select function that works perfectly and returns the value “Week , Height growth - weekly (cm)”
SELECT(User[Fields], [User_Email] = Usersettings(username))

Yet when I wrap this same function in an IN statement to detect if it returns “Week”, it return False instead of the expected True.
IN(“Week”, SELECT(User[Fields], [User_Email] = Usersettings(username)))

Any help on what I am missing here would be much appreciated.

[Aleksi]

If it will return only one value, you should use the whole string for the IN expression like…
IN(“Week , Height growth - weekly (cm)”, SELECT(User[Fields], [User_Email] = Usersettings(username))). Is that the case?

[adambc · Accepted solution]

Hi Aleksi, thank you I wrapped my select statement in a SPLIT() statement to ensure it was a list and this worked.