Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community, I want my numbering sequence to be 1, 2, 3... instead of 1, 10, 2, 3.. how to address this issue simplest way possible or the many alternatives? Thank you
You could create calculated columns like the following:
Supplier Sort = VALUE(SUBSTITUTE([SUPPLIER_NAME], "SUPPLIER ", "") )
If you want to sort your text column differently you need to introduce a sort column. Read about "Sort one column by another column".