Forum Discussion
Error cyclic dependency when sorting by calculated column.
Hello data wizards, I have this problem in Power BI desktop. I need to sort months in a matrix according to their year. The months go like this: Jan, Feb, Mar, Apr, May, Dec the December ...
zidek22 , I have given formulas in last update to sort the month on month order, not the text. Just adjust to your table and that will work
It worked! I added a second DateView column that I use to display the dates, then I created the DateSort column that is in a YYYYMM format and can be sorted. After that I sorted the DateView column by the DateSort column. Basicaly I never use the original Date column in my visual. Just writing this up for future reference if anyone needs it.
Thank you so much! Bye amitchandak