Forum Discussion
Help in calculating "distinct count".
Hi.
I have a database of customer id and dates of consumption and I have to calculate:
quantity of distinct customers (total).
increase of new customers over time (monthly).
Example below:
database: customer id | date of consumption | unit | delivery channel | year
Anyone to help? Tks!
Found this article and solved my problem!! Hope it helps more people.
https://finance-bi.com/blog/power-bi-new-and-repeat-customers/
3 Replies
- jennratten
Super User
Hello -
Here are two great resources that have a lot of examples of calculating change over time.
https://radacad.com/month-over-month-calculation-in-power-bi-using-dax
https://www.sqlbi.com/p/dax-patterns-month-related-calculations/
Found this article and solved my problem!! Hope it helps more people.
https://finance-bi.com/blog/power-bi-new-and-repeat-customers/
Hi gtrani ,
Glad to hear that your problem has been solved. Please mark your reply as a solution. More people will benefit from it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
