This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have data with columns as customer ID, product, week, month, sales (attached). I want to calculate the lost/new/growing/declining weekly customer trend and show it in power BI. (Attached is the output snapshot for reference). Here is the definition of definition of the metrics
NEW – Volume in recent 13 weeks; no volume prior 13 weeks
LOST – No volume in recent 13 weeks; volume in prior 13 weeks
GROWING – Volume in both recent & prior 13 weeks; most recent 13 weeks > prior 13 weeks
DECLINING – Volume in both recent & prior 13 weeks; most recent 13 weeks < prior 13 weeks
@agoyal28 One question: Your description mentions looking at this on a rolling 13 week window for each customer. However, your example input shows the information aggregated at the month level (assuming I'm reading the chart correctly). These two things wouldn't add up. Can you clarify?
so there are probably much more elegant solutions to this, but I think this works. The concern is the eventual size of the data because of all the combinations. I haven't checked the customer labels, but you'll get the idea.