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 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
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/IF-AND-dax-Formula/m-p/293991#M129654
@v-chuncz-msftThank you, I'm after a solution directly inside of the power query enviroment.
Regards,
Mathew
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |