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.
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
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?
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.
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
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |