Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mwinds
Helper I
Helper I

Running total and count up until last quarter

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

 

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Helper I
Helper I

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.