Forum Discussion
help with relationship
Hi guys,
The highlighted table is a union of the the two columns on the right, which gives me a list of each individual label, regardless of whether it appears as label 1 or label 2. Distinct Union.
True_Labels =
DISTINCT (
UNION (
DISTINCT(FILTER(VALUES('trustpilot_api_reviews_labelled'[Label_1]),LEN('trustpilot_api_reviews_labelled'[Label_1])>0)),
DISTINCT(FILTER(VALUES('trustpilot_api_reviews_labelled'[Label_2]),LEN('trustpilot_api_reviews_labelled'[Label_2])>0))
)
)
My questions, is how can I join the new table with the the table that has the label 1 and 2?
1 Reply
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
