I want to show a previous score value

[Dyke211]

Hello, I want to display previous score value of each "score title".. Like for instance "Strategy" in Month 01-june-2024 has a score value of  3 but in December 2023 Strategy has a value of "2" so i want to display this value score of "2" in the previous score column . Kindly help me dax code

What I Have                                                                                       What i Want

 

[AntrikshSharma]

@Dyke211 Try these:

CALCULATE ( 
    SUM ( Table[Score Value] ),
    OFFSET ( 
        -1,
        ALL ( Table[Account], Table[Score Title], Table[Score Value], Table[Assessment Month] ),
        ORDERBY ( Table[Assessment Month], ASC ),
        PARTITIONBY ( Table[Account], Table[Score Title] )
    ),
    REMOVEFILTERS ( Table )
)

and 

VAR CurrentMonth = 
    Table[Assessment Month]
RETURN
    CALCULATE ( 
        MAX ( Table[Score Value] ),
        Table[Assessment Month] < CurrentMonth,
        ALLEXCEPT ( Table, Table[Score Title] )
    )

[Dyke211]

I just tried but didnt work

[Dyke211]

Still in need of a help

[aduguid · Accepted solution]

Previous Score = 
VAR CurrentAccount = 'Table'[Account]
VAR CurrentScoreTitle = 'Table'[Score Title]
VAR CurrentAssessmentMonth = 'Table'[Assessment Month]

RETURN
    CALCULATE(
        MAX('Table'[Score Value]),
        FILTER(
            ALL('Table'),
            'Table'[Account] = CurrentAccount &&
            'Table'[Score Title] = CurrentScoreTitle &&
            'Table'[Assessment Month] < CurrentAssessmentMonth
        )
    )