Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.