Forum Discussion
Relationship
How to relate the Concatenate Column of this two tables in the given scenario as both columns have few lines which are not existing in the concatenate column of other table? Cost Table ...
Hi Anonymous ,
You may create intermediate calculated table like DAX below, then create relationships with original two tables in "Both" Cross filter direction.
Intermediate Table= UNION(DISTINCT(Cost[Concatenate]), DISTINCT(Staff[Concatenate]) )
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.