Forum Discussion

nckpedersen's avatar
nckpedersen
Icon for Helper I rankHelper I
4 years ago
Solved

Fields with the same value are not aggregating in table

I have a calculated column with a simple lookupvalue formula which appends an organization name to a unique id from another table. When I put the new column in a table, all of the duplicate values...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

nckpedersen , Please use clean and Trim in Power Query.

If there is a sort column for the organization, make sure that have only one value for one value of the organization.

 

Also, make sure that the count of Organization is a count or sum

 

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

  • nckpedersen's avatar
    nckpedersen
    Icon for Helper I rankHelper I
    4 years ago

    Thank you! It was indeed because I set a sort column. Interesting effect, might use later now that I know how it works! I really appreciate the help!