Forum Discussion
mgcchkn
3 years agoFrequent Visitor
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...
- 3 years ago
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
mgcchkn
3 years agoFrequent Visitor
I figured it out, but it takes forever for it to load now. It takes between 60-90 seconds.
- v-easonf-msft3 years agoCommunity Support
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- mgcchkn3 years agoFrequent Visitor
That worked great! Thank you!!!