Forum Discussion

saikiran's avatar
saikiran
Icon for Helper I rankHelper I
5 years ago

How to find repeated customers

Hi all,

Good Morning!!

 

Hope all are doing well.

 

Actually i have one table in this table i have students data but i want to compare existing students to new students. currently how many students are available inmy data these students are again coming to studying any other course to current month i don't want this student count for current month count why because he is already existing student in my data so i want to show only new student till now not studying in my organization i will take these students new students. so if any body knows solution for this problem please help me as soon as possible.its's urgent

 

 

Thanks In advance!!

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    saikiran check this post and tweak it to fit into your model.

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

     

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi saikiran 

    Can you share some dummy data and expected result in table format? It will help us understand your requirement better and find solutions accordingly.

    For what period you want to count existing students and new students? Every month or only current month? How to define a new student? Do you count a student as a new student when his/her name appears the first time in the table?