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.
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 have their own row. Using the original column, those values are aggregated. Even worse, some are actually aggregating... I've copied the values into excel and run a simple deduplication and the values all disappear so I know there are no spelling changes, added spaces, etc.
I cannot seem to find any reason for this. Suggestions?
Solved! Go to Solution.
@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
Hi,
Share the download link of the PBI file.
@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
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!
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |