Forum Discussion

009co's avatar
009co
Icon for Helper IV rankHelper IV
3 years ago

DAX Date table relationship to query table date gives circular dependency

My report has a DAX Date table. It is working successfully to create a relationship between it and a one of my queries.   However, when I try to create a relationship between the DAX date table and...
Need Help
009co's avatar
009co
Icon for Helper IV rankHelper IV
3 years ago

Hey thanks. That video describes issues that arise when a DAX table that is created from query table and the query table relationship is attempted.

 

In my issue the query table is completely unrelated to the DAX date table. It is also completely unrelated to the first query table that successfully allows a relationship between itself and the DAX date table.

 

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Honestly I can't tell what/where exactly is the issue if I don't see the model. I am sure the video covered most of the issues related to Circular Dependencies that's why I might think the problem is coming from your date table. How did you created? Using Calendarauto()? this function takes the existing column dates in your model. 

    Share a sample of your model and let me take a look into it.