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

[101Mathew]

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

[v-chuncz-msft]

@101Mathew,

You may take a look at the post below.

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

[101Mathew]

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

Regards,

Mathew