Forum Discussion

GarryPope's avatar
GarryPope
Icon for Advocate I rankAdvocate 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 nu...
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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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))