Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
learner03
Post Partisan
Post Partisan

Circular dependency error

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-

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,.........Till all sizes till 38 sizes and  at last Table[Size (Apparel)]+38))))))
After that on Size coloumn I used sort by SortOrder-
akapoor03_0-1631859618893.png

But, it gives me below error( Blue is Table name-

akapoor03_1-1631859705817.png

 

How can I sort sizes in the form 0,2,4,6,8..S,M,L,Xl.2Xl...so on?

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@learner03 ,

 

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

 

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@learner03 ,

 

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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.