Forum Discussion
Circular Dependency within Table for calculated column
Hi there, I've been tyring to correct a circular dependency between two calculated columns and I can't seem to find the answer. I have one table that I am using for the calculations, there ar...
Try using it as measure instead of calculated column.
With your sample it returns Group1 for all but the last row (which shows Other as MarginClass & MarginPL show NaN).
Not sure if this is correct result or not.
I can't use measures since I need to use these groups as a visualization axis.
Normally, I'd do bucketing and categorizing in Query Editor stage then.
I'll have to go through your file more in detail to follow all the steps and criteria applied. Will see if I have time tomorrow or later in the week.