Payment Behaviour

[ashraf_SISL1]

Hi Team,

I want to know the payment Behaviour of my consumers. Consumers make payments every month, sometimes 02-03 times in a month. All payments in a single month to be counted as 01 payment & basis on that I want to know the payment Behaviour  of every consumer as per below,

01 to 03 times  - Defaulter

04 to 06 times  - Irregular

07 to 10 times   - Alternate

11 to 12 times    - Regular

Sample data is here,

https://app.powerbi.com/groups/me/reports/67b9a734-b5c6-4b5d-a132-72d26afbc662/ReportSectioncd765e74...

Thanks, 

[amitchandak]

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"
)

[ashraf_SISL1]

Hi all,

Here is the link for access my sample data,

Thanks..

[v-lid-msft]

Hi @ashraf_SISL1 ,

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,

[ashraf_SISL1]

@v-lid-msft 

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

https://sislinfotech-my.sharepoint.com/personal/ashraf_khan_sislinfotech_com/_layouts/15/onedrive.as...

[Greg_Deckler]

I'm with @vanessafvg that link doesn't work for m.

[vanessafvg]

can you download the pbix rather, i dont have access to this