cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
101Mathew Regular Visitor
Regular Visitor

Merge Query dealing with Duplicates (due to key being repeated)

Hi All,

 

In the world of insurance, I'm stuck with having to link claims table from suppliers by the policy number onto the risk details table.

 

The claims table can have multipule claims per policy, and as the claims file does not have the cover period of a policy, a policy number can appear numerance times as the policy is renewed.

 

My challenge:-

 

when merged, only for the numeric fields, keep one entry then replace the duplicate entries with null.

 

This currently has me little bit stumped (I'm rather new to Power Query).

 

Any suggestions?

 

Thank you in advance for your time

 

Regards,

Mathew

2 REPLIES 2
Community Support Team
Community Support Team

Re: Merge Query dealing with Duplicates (due to key being repeated)

@101Mathew,

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/IF-AND-dax-Formula/m-p/293991#M129654

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
101Mathew Regular Visitor
Regular Visitor

Re: Merge Query dealing with Duplicates (due to key being repeated)

@v-chuncz-msftThank you, I'm after a solution directly inside of the power query enviroment.

 

Regards,

Mathew