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 Guys,
So I have a problem where I have data coming in from two different sources with different ID's. Often they are duplicates and I want to get rid of them. This is how the data is structured:
Many Thanks in advance.
Solved! Go to Solution.
@P8MCP ,
I'm not sure how this could be done in Power Query, but I think I have a solution in DAX.
Create a Calculated Column:
Flag = SWITCH(
TRUE(),
[Workable_Code] = Blank(), 0,
ISERROR(LOOKUPVALUE( Code[Workable_Code], [Code],[Code] )) = FALSE(), 1 )
Basically, I am flagging each record where it does find a match.
CodeWorkable_CodeFlag
IOG423 | 0 | |
IOG476 | 0 | |
IOG420 | 0 | |
ISM-247 | IOG476 | 1 |
Then you can set your page filter or report filter to Exclude records where Flag = 1.
If you really need to do this in Power Query, you can try searching for a way to apply the same logic.
Hope you might be able to make this work for you either way.
Regards,
@P8MCP ,
I'm not sure how this could be done in Power Query, but I think I have a solution in DAX.
Create a Calculated Column:
Flag = SWITCH(
TRUE(),
[Workable_Code] = Blank(), 0,
ISERROR(LOOKUPVALUE( Code[Workable_Code], [Code],[Code] )) = FALSE(), 1 )
Basically, I am flagging each record where it does find a match.
CodeWorkable_CodeFlag
IOG423 | 0 | |
IOG476 | 0 | |
IOG420 | 0 | |
ISM-247 | IOG476 | 1 |
Then you can set your page filter or report filter to Exclude records where Flag = 1.
If you really need to do this in Power Query, you can try searching for a way to apply the same logic.
Hope you might be able to make this work for you either way.
Regards,
@rsbin
This is genius! It means that I won't actually be deleting my results from the data, but simply hiding them. That was what I was trying to achieve but didn't think it was possible.
This is outstanding I really appreciate your help 🙂 What a great community!
Regards,
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |