Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have just one table and that contains a column sixe with sixes as- 2,8,4,6,M,L, 3XL etc. I need to sort them. For this I created a new coloum called sortOrder and used an If condition-
But, it gives me below error( Blue is Table name-
How can I sort sizes in the form 0,2,4,6,8..S,M,L,Xl.2Xl...so on?
Solved! Go to Solution.
Do it like this
refer: How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Size (Apparel) 1 = [Size (Apparel)]
SortOrder = IF(Table[Size (Apparel)]="2",1,IF(Table[Size (Apparel)]="4",2,IF(Table[Size (Apparel)]="6",3,IF(Table[Size (Apparel)]="8",4,IF(Table[Size (Apparel)]="10",5,
//other
(Apparel)]+38))))))
then
sort : Size (Apparel) 1 on SortOrder
That will not give a circular error
Do it like this
refer: How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Size (Apparel) 1 = [Size (Apparel)]
SortOrder = IF(Table[Size (Apparel)]="2",1,IF(Table[Size (Apparel)]="4",2,IF(Table[Size (Apparel)]="6",3,IF(Table[Size (Apparel)]="8",4,IF(Table[Size (Apparel)]="10",5,
//other
(Apparel)]+38))))))
then
sort : Size (Apparel) 1 on SortOrder
That will not give a circular error
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |