Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a measure that calculates the number of days since a customer's last purchase. Now I need three measures to count the customers that fall into the following segements Active (0-30 days), Lapsed (30 - 60 days), Lost (60 days plus). Is there a DAX pattern that can do this or do I need to come at it from a different angle?
Thanks
Coxy
Hi @Anonymous
You should be able to do this using the Dynamic Sementation pattern.
You just have to set up a segment table, then write an appropriate segmentation measure following the pattern on the above page.
Please post back if you need help with the specifics for your data model.
Regards,
Owen
User | Count |
---|---|
23 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |