Forum Discussion
Solved
Duplicate values after Group By
Refresh fails with message "Column 'Restart Cause' in Table 'new_sort' contains a duplicate value [redacted for company privacy reasons] and this is not allowed for columns on the one side of a many-...
Not sure if this applies here but when I see issues like this it is because M is case sensitive while DAX is not. If you use UPPER or lower case of the column before you group, you will be sure to get rid of duplicates.
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeNot sure if this applies here but when I see issues like this it is because M is case sensitive while DAX is not. If you use UPPER or lower case of the column before you group, you will be sure to get rid of duplicates.
Pat
Thank you mahoneypat! I didn't realize that DAX is case-insensitive.
