Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate difference between invoice amount not based on date

I'm looking for a way to calculate the difference between invoice amount, but not based on dates (month), but based on order of the invoice. So the difference between each invoice per client based on...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    pls try this

     

    Column = 
VAR _l=maxx(FILTER('Table (2)','Table (2)'[client]=EARLIER('Table (2)'[client])&&'Table (2)'[invoice]<EARLIER('Table (2)'[invoice])),'Table (2)'[invoice])
return if(ISBLANK(_l),BLANK(),'Table (2)'[amount]-maxx(FILTER('Table (2)','Table (2)'[client]=EARLIER('Table (2)'[client])&&'Table (2)'[invoice]=_l),'Table (2)'[amount]))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

aaah sorry... its because i use the month and year in the X-axis so the values get summed in the vissual. thanks 🙂

ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

you are welcome