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
Aditi_R
Frequent Visitor

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

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

 

Screenshot 2023-07-10 153702.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Aditi_R , I think the offset function can help

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Aditi_R , I think the offset function can help

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

Thanks a lot!! It is working just fine.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors