Forum Discussion

gonrodrigues's avatar
gonrodrigues
Helper III
10 years ago
Solved

Error: circular dependency

Hey!   Can someone explain why is this happening pls?   Thanks.  
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    I assume these are calc columns, is that correct?  I am aware of a circular dependency "issue" when you write multiple calc columns, and their incrementally refer to all columns in a table. It is very complex and I don't think I can explain it based on what I see. But my suggestion is that you don't write calc columns at all, but instead write measures. Read my article about the difference here. http://exceleratorbi.com.au/calculated-columns-vs-measures-dax/

bhrdrms's avatar
bhrdrms
Frequent Visitor
9 years ago

Hi MattAllington,

 

I found you today and ı read your blog. Nice to meet you :)  I would want to come your course but I live in Turkey.


ı have a problem that ı take"circular depency error", when ı have multiple calculated columns thay you say. 

But ı must do some calculate. can you give me advice.  

 

I have two tables, 1) invoices 2) exchange rate (for USD value) ( this table has "usd banknote selling value" for everyday)

 

I want to take baknote seeling from secondly table according to date. I can it below, it works.
CurrenciesBanknoteSelling_grandtotalprice =
IF(invoices[Currency_code_from_manuel_original]="TRY";
     invoices[new_invoice_grandtotalprice] / LOOKUPVALUE(currency_value[Column1.Currencies.BanknoteSelling];
                                                                                                    currency_value[Date_wholenumber];
                                                                                                    invoices[invoicedate_wholenumber]); 
invoices[new_invoice_grandtotalprice]) 

 

But  ı want to do same formula for grandtotalprofit.  And ı give "circular depency error". :(

 

Can you give me advice,

 

Thank you,

Best regards,

MattAllington's avatar
MattAllington
Community Champion
9 years ago

It's hard for me to understand what is going on here from the description.  Any chance you can produce a sample workbook with non sensitive data and post a link here so I can take a look?  And also try to explain how you want to use what you are trying to build.  Chances are you are not doing it the best way, but unless I know what you are trying to do this for (ie how you will use it) then I can't really comment.