Can this be done with the offset function?

[peterhui50]

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.

[v-jingzhang · Accepted solution]

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]

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

[Ashish_Mathur]

Hi,

PBi file attached.

Hope this helps.