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.
I have two duplicate tables, but one of the tables has around 80 new records that I want to pull out and create a new table just for these added records. The IDs for both of these tables are the same, so what I need is DAX to only select rows from the second table where the ID does not match the ID from the first table. I dont know why I cant wrap my head around this one.
Thanks for the help
Solved! Go to Solution.
Hi @Anonymous ,
Try using EXCEPT(), it is pretty cool!
A table that contains the rows of one table minus all the rows of another table.
https://docs.microsoft.com/en-us/dax/except-function-dax
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
Try using EXCEPT(), it is pretty cool!
A table that contains the rows of one table minus all the rows of another table.
https://docs.microsoft.com/en-us/dax/except-function-dax
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Thanks for this. This is exactly what I need. I was going to build a LEFT OUTER JOIN and figure out how to select nulls from that, etc, but this is much simpler. Thanks again
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |