Creating tables

[Anonymous]

Dear all,

My data model is below 

The tables Overdue,Billing,Bounce,Collection and Register are connected to the table "table",which has the columns AccountNo,Key,Amount,Monthyear,Flag of Overdue,Billing,Bounce,Collection and Register.Now i want to create a table called CurrentOverdue which should have AccountNo,Key,Amount,Monthyear,Flag from tables  Overdue,Billing,Bounce .Then I want to add this Currentoverdue table to the table "Table".I tried it but i got circular dependency error.Is ther any other way to achieve this?

I 

[Stachu]

Overdue, Billing and Bounce are linked together via Table so circular dependency is definately correct
why do you need a new table for that? wouldn't it be sufficient to just calculate a measure for CurrentOverdues?

[Anonymous]

Dear Stachu,

Thanks for ur reply.

Actually i want calculate the Non performing assets.I am calculating it by taking the field EMI from Register.By using RELATED i am calculating CollectionNPA.

Overdue:

Overdueamount/EMI as CollectionNPA

Billing:

Billingamount/EMI as CollectionNPA

Bounce:

Bounceamount/EMI as CollectionNPA

I am concatenating all CollectionNPA into one table

If CollectionNPA >4 then they will be non performing assets.

I am using this CollectionNPA  in Collection ,who are all not paying due's for morethan 4 months.

Regards,

Joshua.

[Stachu]

without DAX bhind this measures and some sample data I cannot really help, but I would think what you want to achive is doable with measure rather than table