Forum Discussion

AdamRobC's avatar
AdamRobC
Helper II
5 years ago
Solved

Circular dependency when sorting by column

Hi,   I would like to sort my month names by a calculated column based on the previous 12 month period. I have got the values populating in a suitable way using relative months to the current month...
  • amitchandak's avatar
    amitchandak
    5 years ago

    AdamRobC , As you are using month name in creating the sort column you can not use that as a sort column

     

    Create a column

    Month Name 1 =[Month Name]

     

    MaxRelativeMonth = CALCULATE(MAX('Calendar'[RelativeMonth]),FILTER('Calendar','Calendar'[Monthly Reporting Period]="TY" && 'Calendar'[Month Name]='Month Ordering'[Month Name]))

     

    Sort Month Name 1 on the new sort column and use that is the visual. Do rename as per need

amitchandak's avatar
amitchandak
Super User
5 years ago

AdamRobC , As you are using month name in creating the sort column you can not use that as a sort column

 

Create a column

Month Name 1 =[Month Name]

 

MaxRelativeMonth = CALCULATE(MAX('Calendar'[RelativeMonth]),FILTER('Calendar','Calendar'[Monthly Reporting Period]="TY" && 'Calendar'[Month Name]='Month Ordering'[Month Name]))

 

Sort Month Name 1 on the new sort column and use that is the visual. Do rename as per need

AdamRobC's avatar
AdamRobC
Helper II
5 years ago

amitchandak thanks, that worked 🙂