Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |