Bring query information based on results from another query

[fabiomg777]

Hello people, how are you guys?

I need some help. Just in the very start of Power BI so I think the best way to learn it (I am going to do some lessons soon) is by posting here and asking to you guys what I need. Just like I learn Excel and VBA.

Ok, so I have two queries from which I bring information.

One is BASE_PGTOS where I have information from contracts that have paid me before, and I have put some condition there to bring only the ones that have paid in the last six months.

Other one is CARTEIRA where I bring information from the actual contracts.

What I want to do is to make CARTEIRA query bring only the contracts there that is on BASE_PGTOS query (the ones that have paid on the last six months).

How can I do that?

[v-xjiin-msft · Accepted solution]

Hi @fabiomg777,

To achieve your requirement, you can simply try Merge Queries option:

Go to Edit Queries -> Merge Queries:

Thanks,
Xi Jin.

[fabiomg777]

Cool xd

Thanks!