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

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.