Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replicate excel formula - recursive substraction

Hi there. I am trying to replicate excel formula in power BI DAX. I have date column(A) with date, progress column(B) with integer, left column(C) with integer. This meant to be project progress moni...
  • AllisonKennedy's avatar
    AllisonKennedy
    6 years ago
    You can do this by calculating a running total or cumulative sum. Then just do 100000- running total.

    So for your example:
    Remaining instances = 100000- SUMX(FILTER(ALL(Table), Table[Date] >= EARLIER(Table[Date]) ), Table[left])
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.