Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Running total issue

Hi all,   Please issue sample of my data set, My data is large data below i am showing sample Client Name Case created date case no type a 22/08/2019 222 x a 22/08/2019 223 x ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    Please try to use following measure formula if it suitable for your requirement:

    Measure =
VAR curr =
    MAX ( 'Table'[Case created date] )
RETURN
    CALCULATE (
        COUNTA ( 'Table'[case no] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            [Case created date]
                >= DATE ( YEAR ( curr ), MONTH ( curr ) - 3, 1 )
                && [Case created date] <= curr
        ),
        VALUES ( 'Table'[Client Name] )
    )

    Regards,
    Xiaoxin Sheng