Forum Discussion
Kudo KingpinCount Active Customers based on Average Monthly transactions
Super Usermichaelsh , refer to these two blogs if they can help
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497
Kudo KingpinI went through these and these are not relevant for my case.
I am looking for the MONTHLY AVERAGE calculation per customer, it the above posts you are showing how to calculate per some period, not MONTHLY in a chosen period.
Think if a user choses Quarter 1, I need to calculate per customer per each of the three months: Jan, Feb, March, even if there were no sales!
I feel that I need crossjoin between customers and months,
Please help