Forum Discussion
How Do I Make a Chart That Counts Activities Start/Finish Within Specific Month
Refer, if this HR blog can help you. This deal with Start and End Date
Thanks amitchandak
I downloaded your file and all of it makes sense. I'm understanding what your process is & the calculations, I'm just limited by my knowledge of codes for this. I can do this for excel just not on here. What I'd like to do is:
I have a table called Updates.
I have all the activities per update, I'd like to have a planned activities count.
I'd like to know how many planned activities were in UP01, to do that I have to cross reference -1 update back, so references UP00.
(It's a bit similar to how you check your Last Period Employee Calc where it goes back a month)
How do I get PBI to understand what month to filter for each UP#? Like UP00 is December-19, UP01 is January-20.
And then only filter for activities planned to start within that month. While being able to adapt as the log gets bigger and more updates are added.