Forum Discussion

KiranGupta15's avatar
KiranGupta15
Frequent Visitor
5 years ago
Solved

Need Delta as a column

Item Sore Rank Delta Item1 100 1 5 Item1 100 1 5 Item1 95 2 15 Item1 80 3 20 Item1 100 1 5 Item1 60 4 10 Item1 50 5 0 Item1 50 5 0 Item2 100 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi KiranGupta15 ,

     

    You could use earlier() function, check the measure below.

    Column = 
var a = CALCULATE(AVERAGE('Table'[Sore]),FILTER(ALLEXCEPT('Table','Table'[Item]),'Table'[Rank]=EARLIER('Table'[Rank])+1))
return IF(ISBLANK(a),0,'Table'[Sore]-a)

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi KiranGupta15 ,

 

You could use earlier() function, check the measure below.

Column = 
var a = CALCULATE(AVERAGE('Table'[Sore]),FILTER(ALLEXCEPT('Table','Table'[Item]),'Table'[Rank]=EARLIER('Table'[Rank])+1))
return IF(ISBLANK(a),0,'Table'[Sore]-a)

 

 

Best Regards,

Jay