Forum Discussion
Sort by column getting "same value" error
jsralat I cannot recreate this. See PBIX. The most obvious cause for this would be some type of mismatch between your two columns like a "January" and a 2 or, a "January " and a 1. Note the trailing whitespace in the second example. Perhaps try applying a clean and trim operation on your Month column as well as Period just to be sure.
I went back to my data and found two rows with (blank) for Month and Period. I assigned them a month and period just to test. I then also re-typed the months and corresponding month number in Period, ensuring they were consistent, just to make sure. Refreshed my data and I'm still getting the same error when I try to sort Month by any other column. I'm at a loss.
I have the same issue. I created custom size buckets column (B) for a numerical column (A). Then I created a custom sort column (C) using SWITCH() based on that custom buckets column (B). I get this error. Went through my entire data to ensure that one value of C corresponds to only one value of B. I still get this stupid error. This is beyond nonsensical. Sorting is such a breeze in tools like Tableau where you can even ctl+drag to sort them however you want. DAX is so painful in that it always makes you go the long way for even ridiculously simple things such as these!! 😫😡
