Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to get previous value

I have a sample table as below: Display_Name Effective_Date Department Jason 2/1/2012 TCX Jason 7/1/2012 TCX Jason 7/1/2012 BFDA Jason 8/14/2012 BFDA Jason 8/21/2012 MB...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Anonymous 

     

    Please try this measure:

    Previous Department = 
CALCULATE (
    MAX ( 'Table'[Department] ),
    OFFSET (
        -1,
        ALLEXCEPT ( 'Table', 'Table'[Display_Name] ),
        ORDERBY ( 'Table'[Effective_Date], ASC )
    )
)

     

     

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 

 

Please try this measure:

Previous Department = 
CALCULATE (
    MAX ( 'Table'[Department] ),
    OFFSET (
        -1,
        ALLEXCEPT ( 'Table', 'Table'[Display_Name] ),
        ORDERBY ( 'Table'[Effective_Date], ASC )
    )
)