Correction of Base of Credits and Quotas in Dax or Query

[Syndicate_Admin]

Good!
I need your help. The corresponding table comes from a server, which brings with it an error, because it is auto-loading. If a debtor pays arrears, this action doubles the receipt in the executed month and leaves the corresponding installment without receipt. In the example, installments 7 and 8 (Overdue) were subsequently paid alongside installments 11 and 12.
Additional data:

• Quota receipt, counts the receipts of the corresponding table, related to an ID and Quota column.
• Expired, consider whether the expiration date is past or not.
• Situation, classifies the quota according to the following criteria: Grace, if Overdue=Yes and Amount=0; Mora, if Expired=Yes and Receipt=null; Paid, if I receive<>null; and Futura,if Defeated=No.
• Current State considers the situation of the Credit if it accounts for any installment in Arrears.

ID	Quota	Expiration	Amount	Fee Receipt	Expired	Quota Situation	Current Status
46	1	15/4/2021	$0		Yes	Grace	Nightmare
46	2	15/5/2021	$0		Yes	Grace	Nightmare
46	3	15/8/2021	$0		Yes	Grace	Nightmare
46	4	15/9/2021	$0		Yes	Grace	Nightmare
46	5	15/10/2021	$0		Yes	Grace	Nightmare
46	6	15/11/2021	$0		Yes	Grace	Nightmare
46	7	15/10/2021	$1.000		Yes	Nightmare	Nightmare
46	8	15/11/2021	$1.000		Yes	Nightmare	Nightmare
46	9	15/12/2021	$1.000	1	Yes	Paid	Nightmare
46	10	15/1/2022	$1.000	1	Yes	Paid	Nightmare
46	11	15/2/2022	$1.000	2	Yes	Paid	Nightmare
46	12	15/3/2022	$1.000	2	Yes	Paid	Nightmare
46	13	15/4/2022	$1.000	1	Yes	Paid	Nightmare
46	14	15/5/2022	$1.000	1	Yes	Paid	Nightmare
46	15	15/6/2022	$1.000	1	Yes	Paid	Nightmare
46	16	15/7/2022	$1.000	1	No	Paid	Nightmare
46	17	15/8/2022	$1.000		No	Future	Nightmare
46	18	15/9/2022	$1.000		No	Future	Nightmare
46	19	15/10/2022	$1.000		No	Future	Nightmare
46	20	15/11/2022	$1.000		No	Future	Nightmare
46	21	15/12/2022	$1.000		No	Future	Nightmare
46	22	15/1/2023	$1.000		No	Future	Nightmare

How could you correct, with Dax, the above?

Best regards

[v-luwang-msft]

Hi @Syndicate_Admin ,

If Quota Situation  what you want to get?

Test the below to create a new column:

testtest = IF('Table'[Expired]="Yes"&&'Table'[Amount]=0,"Grance",IF('Table'[Expired]="Yes"&&'Table'[Fee Receipt]=BLANK(),"Nightmare",IF('Table'[Fee Receipt]<>BLANK(),"Paid","Future")))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien

[Syndicate_Admin]

Thanks for the reply, it's helpful. In the same way, it is not the one sought.
If you see, installments 11 and 12 have 2 receipts, they are duplicated. These two "others" correspond to the 7 and 8 respectively, which by not accounting for their receipts are in the situation of Mora. I know it's difficult but I ask here if there is any viable solution using DAX.

Thank you very much for your time and knowledge!