Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a data set like below
Fact table
ID | Content |
1 | a |
2 | b |
3 | c |
4 | d |
sdfsd | e |
rêtr | f |
45 | g |
Dim table
ID |
2 |
3 |
4 |
5 |
45 |
8 |
Now i`d like to remove all the rows in Fact table which have ID appears in the Dim table ( the values in Dim table are Distinct)
How may i achieved that task?
Many thanks
Solved! Go to Solution.
Hi, @Haidannx
Based on my research, the easist way is using 'Merge Queries'. You may go to Query Editor, click 'Merge Queries'.
Then you can make the ID columns from two tables selected and choose 'Left Anti' under 'Join Kind', which keeps only rows from the first table when joining tables.
Finally, you need to right-click 'Dim table' column and remove it. You will get the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Haidannx
Based on my research, the easist way is using 'Merge Queries'. You may go to Query Editor, click 'Merge Queries'.
Then you can make the ID columns from two tables selected and choose 'Left Anti' under 'Join Kind', which keeps only rows from the first table when joining tables.
Finally, you need to right-click 'Dim table' column and remove it. You will get the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |