Hi,
I wrote the following custom column formula:
List.Select(Roles[Role List], each Text.Contains([Jobtitle], _)),
My aim with this formula. I have a "Roles" table with a column "Role List", which contains roles like "Data Scientist, Data Analyst, ..." having a new row for each role.
I also have a table containing the column "Jobtitle" which is containing text. The custom formula is supposed to create a new column where all the roles, from the "Role List" column that are found in the "Jobtitle" are in this new column.
However, now the new column gives me a list for every row with the following error:
Expression.Error: We cannot apply field access to the type Text.
Details:
Value=Data Analyst
Key=Jobtitle
It seems that he for some reason cannot access the Jobtitle column. The title of the column is written correctly and the data in this column is specified as "Text". Can someone help me to resolve this error? Thank you very much in advance!
