Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |