Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a requirement to show how many active items there were by month. The issue I have is counting the item in the intermediary months.
In the table there is a created date, completed date and open/closed status
So for example, if an item was created date was in March 2020 and completed date was in June 2020, Then the item would need to add to the month counts as follows
March April May June
1 1 1 0
Hope this all makes sense
Please search this forum for similar (or even same) problems. There are plenty of them. This is such a popular horse that it's been beaten to death on these pages...
@trevor-adare , refer to this blog , very similar
Check for Current employee
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
25 | |
20 | |
14 | |
8 |
User | Count |
---|---|
71 | |
48 | |
46 | |
20 | |
16 |