Forum Discussion
brentb
3 years agoRegular Visitor
Classification of customer issue
Hi, I am working on grouping our customers into new, active, lost & oneoff. To do so I made 3 measures in my customer table: 1. CustomerTurnover 2. CustomerTurnoverN-1 3. CustomerturnoverN-2 ...
johnt75
Super User
3 years agoHave a read of https://www.daxpatterns.com/dynamic-segmentation/, I think that's what you're looking for.
brentb
3 years agoRegular Visitor
Thanks, I do think this is the right direction. However, I get stuck because the way I group my dealers is a bit different than the author's. I want to group my dealers with a SWITCH formula, but when I process that into the formula of the author it doesn't work.