Previous Quarter

[GarryPope]

Hello Power BI Community,

I have a SharePoint List called AnimalList with two columns:

• Title
• My Date

I can show these in a table, as below:

But I want to show a card that displays the number of rows for the previous quarter.
So no matter what day I'm looking at the report, the card will only show the number of rows for the previous quarter. 

For the data in the screenshot above, the card would show 7 as today is 9th May 2022 so last quarter must have been January, February, March 2022. 

Any help would be greatly appreciated. I've looked at Microsoft Docs Previous Quarter but getting no luck. 

Thanks,

Garry

[Anonymous · Accepted solution]

Hi @GarryPope ,

Please try the following to create a measure:

rows of previous quarter =
VAR _t =
    SUMMARIZE (
        'Table',
        'Table'[Title],
        'Table'[Date],
        "diff", DATEDIFF ( MAX ( 'Table'[Date] ), TODAY (), QUARTER )
    )
RETURN
    COUNTROWS ( FILTER ( _t, [diff] = 1 ) )

Output:

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

[amitchandak]

@GarryPope , Make sure you have a date marked as a date table. And previousQuater needs a date to be selected on page

Try based on today

Last Qtr =
var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _max = eomonth(_max,-1* if( mod(Month(_max),3) =0,3,Month(_max)))
var _min = eomonth(_min,-3)+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))