relate two fields to single field in two different tables

[Anonymous]

 Hi everyone, i would like to know if there is a possibility to link two fields from a table to another field in another table (see the tables in the image). In fact, i have a table containing informations about the sequencing of different applications (the source and the destination) and another table containg the id of the application (called stepId) and its status. I would like to relate the stepId with sourceId and destinationId, in order to filter on the status. An application can be in a source position in one row and also in a destination position in an another row. 

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly share your workaround and Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous]

Hi @Anonymous 

Due to I don't know the values in your table and what result you want, could you provide me more details about your table?

You may provide me a sample table and the screenshot of the result you want .Or you may share me with your pbix file by your Onedrive for Business.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.