Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Minus previous cell value

hi all,

i have this sale table.how do i write the forumla so that the value will show example for Day 1 - 20 sales was made and so on.

I tried using earlier function but lost along the way.

 

DayColumn ADifference
Day 110020
Day 212019
Day 3139149
Day 4188 

 

Thank you very much.

Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    why do you 149, not 49 in the last row?

     

    try

    Difference = 
var _nextVal = CALCULATE(MIN('Table'[Column A]);FILTER(ALL('Table');'Table'[Column A]>EARLIER('Table'[Column A])))
RETURN
if(_nextVal>=[Column A];_nextVal-[Column A];blank())

    do not hesitate to give a kudo to useful posts and mark solutions as solution

5 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    hi Anonymous 

    if i understand you correct try a column

     

    Difference = [Column A]-CALCULATE(MAX('Table'[Column A]);FILTER(ALL('Table');'Table'[Day]<EARLIER('Table'[Day])))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    az38 

    is it possible to use column A for calculation only...

    Perhaps it something simple but i couldnt get it right...

     

     

     

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

       

      try

      Difference = [Column A]-CALCULATE(MAX('Table'[Column A]);FILTER(ALL('Table');'Table'[Column A]<EARLIER('Table'[Column A])))

      do not hesitate to give a kudo to useful posts and mark solutions as solution

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        az38 

        is there a way to show the value for 1st row...