Forum Discussion
mv124
9 years agoNew Member
Circular Dependency error on a calculated field using divide function
I'm trying to create a new column with a divide function. Below are the inputs to this calculated field. Input 1 = Existing field is a whole number from an Excel file. Input 2 = Whole number that ...
dkay84_PowerBI
9 years agoMicrosoft Employee
What about doing a merge in the query editor rather than adding a column using LOOKUP? I'm not sure if this will fix your problem (or is feasible) but this way the column will be loaded into the data model and it shouldn't cause a dependency error