Distinct count running total by month

[Craigc3814]

I am trying to create a formula that creates a cumulative count on project ID for a set of data I have and increases monthly. I can find formulas online that work but only have one filter criteria. (example below)

But I need to factor in the fact that (Projects[Percent Complete] = 100 and Projects[Finishyear] = 2021

Cumulative Task by Finish Date =
CALCULATE(
DISTINCTCOUNT(Projects[PROJECTID]),
FILTER(
ALLSELECTED(Projects),
Projects[TASKNAME]="Advertise Date"))

 

[GraH]

Inside calculate you can add multiple filters.

 

[Craigc3814]

Inside calculate you can add multiple filters.

Got it working for the most part, but I cannot get it to add up by month. My cumulative count is 6 but it is showing me 6 projects each month. The data is like this

January 1
February 2
March 3

So I need the results to be

January 1
February 3
March 6

Right now it just shows me 6 for each month

Cumulative Task by Finish Date =
CALCULATE(DISTINCTCOUNT(Projects[PROJECTID]), FILTER(ALLSELECTED(Projects),Projects[TASKNAME]="Advertise Date" && Projects[PERCENTCOMPLETE]=100 && Projects[Finish Year]=2021),FILTER(ALL(Projects[FINISHDATE]),P6Projects[FINISHDATE]<=MAX((Projects[FINISHDATE]))))

 

[GraH]

@Craigc3814 , I hope someone jumps in. I'm not able to fully grasp what the formula does without seeing the data.
Good luck, sorry for not being more of a help.