Forum Discussion
Running Total Help Needed Please
stokidez ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
But I think this blog should help
No worries amitchandak , here is a very basic sample dataset. Assume the Projects listed below is the entire portfolio (10 Projects).
Project Title Planned Contract Signed Date
Project A 29th May
Project B 27th August 2021
Project C 12th July 2021
Project D 20th September
Project E 3rd September
Project F 2nd September
Project G 25th May
Project H 8th July
Project I 16th July
Project J 14th June
What I would like to show on the first of every month in the visual is the number of current live projects. We can assume that if the date has not passed the Planned Contract Signed Date then the project is still live. Therefore, as an output I would expect to see.......
Date Number of Live Projects Remarks
May 1st 10
June 1st 8 Project A and Project G have completed
July 1st 7 Project A, G and J have completed
August 1st 4 Project A, G, J, C, H and I have completed
September 1st 3 Project A, G, J, C, H, I and B have completed
October 1st 0 Project A, G, J, C, H, I, B, D, E, F have completed