Forum Discussion
Sales Data Questions
Good afternoon, I used to have an account here but could not for the life of me get it to log in - just perpetual circles of signing in. Anyways, traditionally I've used PowerBI for non-sales based ...
seanpratt291 , A sample data would help.
But refer these two blog and video. They will give you idea how to approch the solution then solution
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 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458
https://youtu.be/Q1vPWmfI25o?t=751
First , second purchase can be column Rank on date -Subcategory rank
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns