Forum Discussion

Charuta's avatar
Charuta
Frequent Visitor
4 years ago
Solved

Circular Dependency Error for Calculate

Hello All, Need help to fix circular dependency in order to get the final date In calculations, need to average and then find how much time is required for completion based on last 2 months average...
  • lbendlin's avatar
    4 years ago

    If possible, push the calculated columns computation further upstream (into Power Query or the data source). That will avoid the circular reference issue.

     

    Same for the DateDim - don't do that in DAX, do it in Power Query or further upstream.