Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Here's what I'm looking at. I want to get a rolling number of customers impacted.
1. The customers are broken up into different zones.
2. Each impact has a start_date and an End_date and customers.
3. If the start date of an impact is after the end_date of a previous impact, the customers of the previous impact are no longer added into the rolling customers impacted.
For example:
I have the following measure:
When I select one zone in the slicer it calculates the running customers correctly but when I select two or more zones it calculates the running customers for each zone instead of combining the zones and doing a running total by start_date.
Example data:
Example1:
When 1 zone is selected:
Example2:
When 2 zones are selected:
sorted by date
Sorted by zone:
As you can see it's calculating each zone independently which is what it should be doing but I'm not sure how to get the result I'd like.
Example 3: When sorting by 2 or more zones - What I'm aiming for:
Any help would be much appreciated! Thanks!
Hi @Traceout ,
Can you provide the relevant test data so that I can answer your question as soon as possible? Looking forward to your reply.
Best Regards,
Henry
I've attached a .pbix with the test data. Let me know if you have any questions, I appreciate the help.
https://drive.google.com/file/d/1g3LLsJH9xkmJc0PN0OVWOzmbL4IGYm9x/view?usp=sharing
I should probably also mention that there are more than 2 zones.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |