Filter values base on column from other Query

[Yqy]

Query 1			Query 2
79			80
48			40
80			79
40			98
40			45
98			63
31
null
null
48
63
45
35

I have two Querys, where Query 1 have extra values, and i would like to keep the "null" and the numbers from Query 2 at the sametime. The same number from Query 2 may appear more than once in Query 1, i will also need to keep all of that too. 

Please help, thanks

[Ritaf1983 · Accepted solution]

Hi @Yqy 
To achieve your goal you can (in PQ ).
Duplicate your table twice:
1. For Q1 - nulls :

2. For Q2 no nulls

Then you merge inner Join Q2 no nulls with your original table:

After expanding, filtering out nulls from the new column, and deleting it:

And last union is with a null copy:

them turn off the option of loading to the model those "help" tables:

Result:

Sample file here:Link to pbix 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly