Filtering using another table

[as3znaus]

Hi everyone,

I have a table ONE with the folowwing columns: CODE, PROJECT, STAFF COSTS,REPORT DATE.... and a table TWO with: CODE, PROJECT and START DATE.

I want to create a new column in table ONE that filters by START DATE (which is actually in table TWO)

How can I do this? Should I copy the column from one table to the other?

Thanks in advance

[v-ljerr-msft · Accepted solution]

Hi @as3znaus,

In this scenario, I would suggest you to use Merge Queries option in Query Editor to merge table ONE and table TWO into a single table. For more details about how to use Merge Queries option, you can refer to this article.

Regards

[as3znaus]

Thanks a bunch! @v-ljerr-msft