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

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