Forum Discussion

Rocky_Brown's avatar
Rocky_Brown
Helper I
4 years ago
Solved

summarized data

I have a report that summarizes data based on Year, Qurter and Month.  A have slicers for all 3 elements.  Is there a way to display the summed data to reflect the last month's figures when selecting...
Summed Data
  • Icey's avatar
    Icey
    4 years ago

    Hi Rocky_Brown ,

     

    I create a sample, please check if this is what you want:

    LastMonthData filtered by Quater =
IF (
    ISFILTERED ( 'Table'[Date].[Quarter] )
        && NOT ( ISFILTERED ( 'Table'[Date].[Month] ) ),
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date] > EOMONTH ( MIN ( 'Table'[Date] ), -2 )
                && 'Table'[Date] <= EOMONTH ( MIN ( 'Table'[Date] ), -1 )
        )
    )
)

     

    In this sample, it returns blank when filtered by Date.Month. In you scenario, you can set what you want when filtered by Date.Month.

     

     

     

    Best Regards,

    Icey

     

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

lbendlin's avatar
lbendlin
Super User
4 years ago

Please specify if this is for Report Server or for the Power BI Service.

Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.