I need guidance from all the experts here. I’m stuck in my model and I want to derive some calculations in it and I am struggling with it.
I have created the measures and I’m facing issues in my “Bou” and “C Bou” numbers.
So “Bou#” is calculated from Presentation Data by counting the Loan ID where status = Non-Tech and "C Bou# is also same just that it is linked with Disb Date so to calculate the current month bounce only.
My Master file has the m.o.m data for the customer’s repayment performance (it might have live and closed cases as well) and presentation data has m.o.m repayment status for the customers (Only Live Customers).
Please let me know if anything else is needed from me.
Thanks in advance for the efforts you guys would be putting in.
I have attached the sample file for the reference.
MODEL.pbix (3.4 MB)