Forum Discussion

peterhui50's avatar
peterhui50
Icon for Helper III rankHelper III
4 years ago
Solved

Can this be done with the offset function?

 

 

Is this possible? I've hightlighted the result in red

 

I tried doing this OFFSET= CALCULATE( MAX(Roles), OFFSET(-1, ALLSELECTED(Employee), ORDERBY( Date,1)) but gives me an error.

 

 

 

 

General Comment
Need Help
Tutorial Requests
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi peterhui50 

     

    I can use this measure based on your sample data. 

    OFFSET Measure = CALCULATE( MAX('Table (2)'[Roles]), OFFSET(-1, ALLSELECTED('Table (2)'[Roles]), ORDERBY( 'Table (2)'[Roles],1)))

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi peterhui50 

     

    I can use this measure based on your sample data. 

    OFFSET Measure = CALCULATE( MAX('Table (2)'[Roles]), OFFSET(-1, ALLSELECTED('Table (2)'[Roles]), ORDERBY( 'Table (2)'[Roles],1)))

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      2 years ago

      Is there a way to make the same code but without using offset and orderby?

      I need the same formula, but the version I have doesn't allow me to use those features