Calculate difference between 2 rows of the same column according to the selected filter values

[Aditi_R]

Hello everyone,

I need help in creating a measure which will result in the difference in 'percentage' for each distinct 'student_id'. (Difference with respect to the 'Exam type' chosen.)

As seen in the image, the difference should be 3, -2 and -5 but I am not getting the expected result.

Any suggestions appreciated !

Thanks a lot in advance !!

[amitchandak · Accepted solution]

@Aditi_R , I think the offset function can help

Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

[Aditi_R]

Thanks a lot!! It is working just fine.