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
Icon for Community Champion rankCommunity 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