Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How does one go about troubleshooting where/why a circular dependency is happening and how to fix it? I get an error message that lists the columns involved which is nice but it doesn't help me in understanding how/why these two columns are bumping heads:
Neither one of these formulas reference nor depend on each other for any calculating so I don't know what the issue is...
Solved! Go to Solution.
Hi @Anonymous
For a start, I would change to use the SWITCH function over your use of nested IF statements. This will make it easier - and I recommend formatting your calculation.
Once you have this, you can comment sections of the function to help isolate and quickly identify which part is causing the issue.
Hi @Anonymous
For a start, I would change to use the SWITCH function over your use of nested IF statements. This will make it easier - and I recommend formatting your calculation.
Once you have this, you can comment sections of the function to help isolate and quickly identify which part is causing the issue.
@Phil_Seamark thank you! I'm not sure how it's working under the hood but changing my NPS Bonus from a nested if to a switch made the circular dependency disappear.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |