Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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 |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |