Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello -
I have a data set that includes scopes of work and the activities associated with each scope. Each week, new scopes are added. I would like to be able to get a count of these scopes, week over week. I'm able to get a count of new scopes this week, but I'm having difficulty getting them for each week.
This is how I'm getting the count this week:
Hi @Anonymous
Your scenario is similar to the New and Returning Customers pattern: New and returning customers – DAX Patterns. You could refer to its solutions to get some ideas.
Additionally, if you could share some sample data (remove sensitive information), we could try to find some simpler solutions. And how do you define a new scope? A scope that appears the first time or a scope that just doesn't exist in previous week?
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
68 | |
67 | |
41 | |
39 |
User | Count |
---|---|
48 | |
44 | |
29 | |
28 | |
28 |