Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello Friends/experts,
I have a requirement to create a Bar/Line chart with like Active projects per month. and I have created three measures to do so..
1. VAR_NUMBER_PROJECTS_CREATED = CALCULATE(COUNT(GP_PROJ_JEP_OPEN_CLOSE_COUNT_V[REQUEST_ID]),FILTER(GP_PROJ_JEP_OPEN_CLOSE_COUNT_V,GP_PROJ_JEP_OPEN_CLOSE_COUNT_V[CATEGORY]="GeneralProjects_Created"))
2. VAR_NUMBER_PROJECTS_CLOSED = CALCULATE(COUNT(GP_PROJ_JEP_OPEN_CLOSE_COUNT_V[REQUEST_ID]),FILTER(GP_PROJ_JEP_OPEN_CLOSE_COUNT_V,GP_PROJ_JEP_OPEN_CLOSE_COUNT_V[CATEGORY]="GeneralProjects_Closed"))
3. VAR_ACTIVE_PROJECTS_GOOD =
[VAR_NUMBER_PROJECTS_CREATED] - [VAR_NUMBER_PROJECTS_CLOSED]
if you see the line in below chart ( attached), there are 17 PMATT projects for April 2022, 8 PMATT projects in May 2022 , 3 pmatt projects in June 2022, etc...
My requirement is to show PMATT projects like below..
for April 2022 = 17
for May 2022 = 25 ( 17+8)
for June 2022 = 28 (17+8+3)
for July 2022 = 36 ( 17+8+3+7)
etc...
How do I achive it? please send me formulas if possible so I can understand it .Thank you so much.!
-Vpat
Solved! Go to Solution.
@Patv Timely, I just posted this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Running-Total/td-p/2755666
@Patv Timely, I just posted this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Running-Total/td-p/2755666
Thank you Greg_Decklet. Your solution works. Appricate your help.