Forum Discussion
Solved
Percent deviation from previous value
Index Name Test Date Test Status Test Duration Current Test Previous Test 331891 John 8/10/2022 APPROVED 24 200 331892 John 5/4/2022 APPROVED 24 71 331893 John 7/6...
Hi， mgcchkn
Take a try formula like below:
Previous Test = VAR _PreviousTestDate = CALCULATE ( MAX ( Student[Test Date] ), FILTER ( ALL ( Student ), Student[Name] = MAX ( Student[Name] ) && Student[Test Date] < MAX ( Student[Test Date] ) ) ) RETURN CALCULATE ( MAX ( Student[Current Test] ), FILTER ( ALL ( Student ), Student[Name] = MAX ( Student[Name] ) && Student[Test Date] = _PreviousTestDate ) )Percenatge = DIVIDE(MAX(Student[Current Test])-[Previous Test],[Previous Test])Best Regards,
Community Support Team _ Eason
I figured it out, but it takes forever for it to load now. It takes between 60-90 seconds.
Hi， mgcchkn
Take a try formula like below:
Previous Test =
VAR _PreviousTestDate =
CALCULATE (
MAX ( Student[Test Date] ),
FILTER (
ALL ( Student ),
Student[Name] = MAX ( Student[Name] )
&& Student[Test Date] < MAX ( Student[Test Date] )
)
)
RETURN
CALCULATE (
MAX ( Student[Current Test] ),
FILTER (
ALL ( Student ),
Student[Name] = MAX ( Student[Name] )
&& Student[Test Date] = _PreviousTestDate
)
)Percenatge = DIVIDE(MAX(Student[Current Test])-[Previous Test],[Previous Test])Best Regards,
Community Support Team _ Eason
That worked great! Thank you!!!