Forum Discussion
Sort by calculated column
Hi Power BI Community! I have this calculated column: Target Data HQ = var _diff = TrackET[Aver. Note to delivery h] return Switch ( True() , _diff <= 42, " < 42 h" , _diff <= 48, " <...
So your last entry is the literal number 6, while the rest are strings - i'e "5- Target...bla bla". I think that'd throw an error once you get there.
I have an example file here:
https://www.dropbox.com/s/729i58ovutw1fvv/Example.pbix?dl=0
I think probably your issue is that you're switch statement on your sort column, is still pointing to the Measure, instead of an actual column. I think you'd need a column with [Avg. Note to delivery h], then reference that column for both your SWITCH column , and your SORT column.
I don't suppose you can upload your file?