Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Dyke211
Helper I
Helper I

I want to show a previous score value

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

 

Screenshot 2024-05-22 144432.png Screenshot 2024-05-22 145247.png

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

aduguid_0-1716432779595.png

View solution in original post

4 REPLIES 4
AntrikshSharma
Community Champion
Community Champion

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

 

 

I just tried but didnt work

Dyke211
Helper I
Helper I

Still in need of a help

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

aduguid_0-1716432779595.png

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.