Forum Discussion
need to match data from a different table that includes the text of the current table column
I have a sysid and a status column in table 1, and I need to search for and retrieve data from table 2's sysid column that includes the text from table 1's sysid column Expecting output ...
Thanks for the reply,
but, i am getting error like this when I tried
AmiraBedh
Super User
Super UserI tried to reproduce what you provided in the screenshot. You need to create a calculated table like below :
Table 2 = FILTER('Second Table', CONTAINS('First Table', 'First Table'[sysid], 'Second Table'[sysid]))
I am attaching the PBI file.
- AmiraBedh
You are trying to create a calculated column while in the solution I provided it is a calculated table
Can you provide your expected output ?
Same error for calculated table also
expected output:I am attaching the PBI file.