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 ...
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.
