Forum Discussion
Payment Behaviour
Did not saw the data. You need to do something like this, first group the data at month and then use
payment count =sumx(SUMMARIZE(Table,table[Month Year],"_sum",sum(Table[payment])),if([_sum]>0,1,0))
Or
payment count =sumx(SUMMARIZE(Table,Table[Customer ID],Table[Month Year],"_sum",sum(Table[payment])),if([_sum]>0,1,0))
Switch(true(),
[payment count] <=3 "Defaulter",
[payment count] <=6 "Irregular",
[payment count] <=10 "Alternate",
[payment count] <=12 "Regular"
)
Hi all,
Here is the link for access my sample data,
Thanks..
Hi Anonymous ,
We do not recommend to share the report link within this public forum. But actually We cannot understand your data model clearly, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to One Drive and share the link here. Or you can use table using fake sample in your reply.
Best regards,Hi,
We just wanted to know the consumer payment behavior with the below parameter,
All payments of a consumer in a single month to be counted as 01 payment
01 to 03 times - Defaulter
04 to 06 times - Irregular
07 to 10 times - Alternate
11 to 12 times - Regular
below is the sample file
