Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Payment Behaviour

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/ReportSectioncd765e746dd0345a5ccd

 

Thanks, 

 

Tips and Tricks

6 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    6 years ago

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

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi all,

       

      Here is the link for access my sample data,

       

       

       

      Thanks..

      • v-lid-msft's avatar
        v-lid-msft
        Community Support
        6 years ago

        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,