Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |