Forum Discussion

GarryPope's avatar
GarryPope
Advocate I
4 years ago
Solved

Previous Quarter

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    amitchandak
    Super User
    4 years ago

    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))