Forum Discussion

P0ach3r1's avatar
P0ach3r1
Frequent Visitor
2 years ago

A cyclic reference was encountered

Hi I'm trying to get a power query to work and each way I try I'm encountering the cyclical reference error.   So I can get this info in DAX but final aim is to have dynamic filters for a matrix - ...
Need Help
AlienSx's avatar
AlienSx
Super User
2 years ago

hi, P0ach3r1 first, use SurveyCycle as nullable text.Otherwise your function won't accept nulls. Other than this I don't see any problems with your function. How about Source = #"Client_list"? Does it feel good?

P0ach3r1's avatar
P0ach3r1
Frequent Visitor
2 years ago

Hi - #"Client_list"? Does it feel good?

 

Client_list is the name of the table so I assume so?

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago

    P0ach3r1 your code works just fine. I believe that either smth is wrong with Client_list or bad things happen outside of your code. 

     

    • P0ach3r1's avatar
      P0ach3r1
      Frequent Visitor
      2 years ago

      Thanks for taking the time to support.  I was trying this last night in another table and got the same error.  I then did a join to pull survey cycle across to Client_list table.  Both times the query to calculate the current company quarter worked fine but the query for CSATDue fails.  I also combined both queries to see if that resolved it (so calculated current quarter then did the lookup vs other columns) but got the same cyclical error.  Maybe I need to rebuild client list.