Forum Discussion
Solved
Remove Duplicate Values in Column
Hello, I am trying to create a table by Client ID using the data in the top table of the screenshot below. When summing the eligible amount by client id, I receive a value of $10,000,000 fo...
gmasta1129, two ways to achieve what you're after is:
1. Create a unique key that merges Client ID and Post Code, OR
2. Use MAX to return the maximum amount for the respective Client ID.
Firstly, though, I recommend you attempt the earlier options I provided so that assumptions are tested for fact and proven not to work.
All the best with your challenge.
Theo 🙂
Hi gmasta1129
Do the following:
1. Click on Transform Data in the Home tab of the Power BI ribbon.
2. Click on the column you want to remove duplicates.
3. Right click on the column title and click "Remove Duplicates"
Hope this helps 🙂