Forum Discussion

mgcchkn's avatar
mgcchkn
Frequent Visitor
3 years ago
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...
  • v-easonf-msft's avatar
    v-easonf-msft
    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