Forum Discussion
Using CONTAINSSTRING function inside CALCULATETABLE to filter partial string matches to multiple str
table =
DATATABLE (
"Name", STRING,
"Code", STRING,
"ID", INTEGER,
{
{ "asldkjfaaa", "ABC", 1 },
{ "jdfkbbb", "ABC", 2 },
{ "dskhgaaa", "XYZ", 3 },
{ ...
I forgot to mention in my original post that I don't just want to filter out a partial match to "aaa" but also to "bbb" and so on. My actual problem includes a list of about six such strings. I can have my query take the form of something like
FILTER(FILTER(FILTER....But I am not satisfied with how that solution looks
