Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Im getting error - Circular dependency was detected

Hi    I have a column "Concat TimePeriod", which have values below January Febuary May Febuary YTD March YTD September YTD     Data type i used for the below column is Wholenumber,Aggregat...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

This error should be caused by your want to sort [Concat TimePeriod] column by [Month_rder] column which was created by dax based on [Concat TimePeriod] column.

There is a blog about this issue, your may refer to it for more details.

Here I suggest you to add an index column in Power Query then sort [Concat TimePeriod] column by index column.

Result:

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

 

Thanks for the response, I have gone through the blog which i'm not able to resolve the issue.

Understanding circular dependencies in DAX - SQLBI

 

When i create a Index column, then it will create a sequnece number for each row, but for me the index need to be created only for Concat TIme period, and this column value can be repeated many times so that the index number will be differnt with same Concat Time period column, which doesnt solve my issue.

 

Thanks,

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    I think your problem is that you may have duplicate [Concat TIme period] or your Concat TIme period is not sort as you want in your table. Power Query doesn't have Switch function. Here I suggest you to try to add a conditional column in Power Query, then you can sort [Concat TIme period] by that custom column. 

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      HI Anonymous 

       

      Thanks for your response and approach, Actually earlier we created a simple excel as the same and imported but it causing a problem - so we need to create it as a single Sort column that need to be come in single table.

      so didnt follow that apporach.

       

      whatever you shared is simillar apporach. Thanks for the update.

      Can you help on the below another issue - which i'm not able to figure out , but made it as accept as solution from my end but its not working - i'm unable to make it as not solution.


      https://community.powerbi.com/t5/Desktop/Selected-Value-and-IF-Else-statement-issue-Dynamic-Calculations/m-p/2218049#M810365