Running total and count up until last quarter

[mwinds]

Hi all,

I am using a directquery with dataverse to create a dashboard.

I have created a running total using a quick measure. 

Count of Projects Created in Date = 
CALCULATE(
	COUNTA('projects'[Date Created]),
	FILTER(
		ALLSELECTED('Date'[Date]),
		ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC)
	)
)

I'd like to create another running total that only goes up to the previous quarter. 

I'm unsure on how to do this.

[Anonymous · Accepted solution]

Hi @mwinds ,

Please have a try.

Count of Projects Created in Previous Quarter =
VAR PrevQuarter =
    DATEADD ( TODAY (), -1, QUARTER )
RETURN
    CALCULATE (
        COUNTA ( projects[Date Created] ),
        FILTER (
            ALLSELECTED ( Date[Date] ),
            ISONORAFTER ( Date[Date], PrevQuarter, DESC )
        )
    )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwinds]

Can anyone help? I'm sure there's a way to do this. Any help is appreciated.