Forum Discussion
Solved
Sort Month Single Letter Multiple Years
Hi all, Using PBID Oct, 2024. I created a Calc Column in my Date Table for the Initial of the month name and made it unique using UNICHAR(8203) below I'm trying to sort this columns but I keep...
Hi tecumseh ,
After further research, I think it's the zero width space string is too long causing the sort to fail.
As a workaround, please try to sort in visula rather than sort in table. And then you can hide the column.
Best Regards,
Wearsky
Anonymous
The Rankx solution is returning a circular reference error.
Any thoughts?
Sample pbix is here
thanks,
-w