Forum Discussion
how to filter array column from another array column
Hi! How to filter column 2 from column 1? the result should be in column 3. In each row, the length of arrays is different.
I tried this
DistinctValuesArrayColumn1 =
DISTINCT(FILTER(RELATEDTABLE(reviews_reviews),
NOT(ISBLANK(reviews_reviews[Assigned]))),
reviews_reviews[Next_Action])
the issue is:
Too many arguments were passed to the DISTINCT function. The maximum argument count for the function is 1.