topic Re: I want to show a previous score value in DAX Commands and Tips

I want to show a previous score value

Dyke211 — Wed, 22 May 2024 14:12:18 GMT

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

Re: I want to show a previous score value

Dyke211 — Wed, 22 May 2024 14:12:39 GMT

Still in need of a help

Re: I want to show a previous score value

AntrikshSharma — Wed, 22 May 2024 17:37:51 GMT

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] ) )

Re: I want to show a previous score value

Dyke211 — Wed, 22 May 2024 21:59:10 GMT

I just tried but didnt work

Re: I want to show a previous score value

aduguid — Thu, 23 May 2024 02:53:10 GMT

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