Absolute Value Difference Between Two Non-Consecutive Rows (Same IDs)
Hi PBI Community!
I have a table similar to the below:
DATE ID GPA
12/1/2021 ABCD 3.8
12/1/2021 ABCD 4.0
I am using tables in my visual and would like to include a flag for any variance in the GPA greater than 1.5 between the same ID/Student's GPA. So, in this case, ID: ABCD would have a variance of .2 -- The GPA's could come in on the same date, which is why I am having a bit of a struggle. Also, I'd like the absolute value, as opposed to perhaps a negative value.
I may put the .2 in the table itself or write a conditional expression that says something along the lines of 'if the variance is >= 1.5, then Flag, ""'
Thanks All - Very much appreciate all of the help provided in this community!