Hi
Help please …
I have customers that predict to spend £x per month. I’d like to calculate at both
a) the customer level - the number of months it took them reach their predicted level of spend
and
b) the average number of months per Sales Grouping to reach their predicted level of spend over a given time period
For this I’m guessing I need to first get the “original banding” based on their predicted sales onto the Customer table. I’ve tried adding a column with SWITCH but can’t get the syntax correct. Grouping Segmenting -Upload.pbix (710.4 KB)
Hi @AliB, while waiting for other members to jump in, I suggest using the forum search to discover if your query has been asked before by another member.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!