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.   ...
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

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...

       

      • az38's avatar
        az38
        Community Champion
        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