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 UserYou 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.
- AmiraBedh
Based on the PBI file you provided :
Table 1 :
Table 2 :
the output will only contain data for the row with sysid=KLS in the table 2 and the status will be DONE.
The other rows will have status null as there is no matching between sysid from Table1 and syside from Table2 for the values HGF, KNF, JKO, IOK