Forum Discussion
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 - ...
P0ach3r1 your code works just fine. I believe that either smth is wrong with Client_list or bad things happen outside of your code.
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.