Forum Discussion
IF Function
I figured it out!!!! I had to make my expression a measurement and not a calculated column!!!! So embarassed thank you for your help~!
Hey,
can you please provide sample of your table 'Last Quarter', also the column [Loan Number].
Are there more calculated columns besides Avg. Units in your table?
Please have look at this article: http://www.sqlbi.com/articles/understanding-circular-dependencies/
Regards
Tom
I coppied a section of my table in the question. The loan number is just a unique identifier i use to get a count of units.
Hey,
unfortunately I can't fully reproduce your issue, based on your sample data, due to the missing column that you used for your "Calculated Column".
Did you check the other option and did you already checked the article.
Regards
Tom
sorry, yes I looked at the article none of it made sense to me. Not sure what you are missing if it's just the loan number. It's the Units column as a Distinct count to aggregrate it based on my originator.
What the article explains, is why you get the error message, so I guess it should mean something.
Yes I can't reproduce your issue, because I can't use your formula, to recreate a calculated column (the root case, for the error message) by using calculate.
This makes it impossible to help you any further, because the issue can't be recreated by the data you provided.
Regards