Addition in powerBI

Question

&nbsp;I Want to calculate the current day backlog ,so need to do addition in the below-mentioned way.Since I am new in Power BI,i searched alot but not finding solution. can someone tell me how to do this in power BI through measure or DAX or any possible way.&nbsp;&nbsp;&nbsp;I want result like column 2 which adds previous value+ current valueColumn 1Column 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2030(10+20)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1545(30+15)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2570(45+25)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

vivran22 · Answer

Hello&nbsp;rohitchouhan ,&nbsp;You may try this:&nbsp;&nbsp;Running Total = 
VAR _Current = 'Table'[Index]

VAR _Filter = 
    FILTER(
        'Table',
        'Table'[Index] &lt;= _Current)
VAR _Sum = 
    CALCULATE(
        SUM('Table'[Column 1]),
        _Filter)

RETURN
_Sum&nbsp;&nbsp;For this formula to work as calculated column, you need a column as index. Either you can use a already existing column in your table which has a serial order (it can be a date column also), or you can add Index column using Power Query:&nbsp;Cheers!VivekIf it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)Blog: vivran.in/my-blogConnect on LinkedInFollow on Twitter

anonymous · Answer

if you already have a date column in your dataset, you can try this,cummulative sum = CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[date]&lt;=EARLIER('Table'[date])))&nbsp;

vivran22 · Answer

rohitchouhan&nbsp;&nbsp;I just noticed that you like my reply is there anything I am missing to mark that as a solution?&nbsp;Cheers!VivekIf it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)Blog: vivran.in/my-blogConnect on LinkedInFollow on Twitter

Forum Discussion

Addition in powerBI

3 Replies

Related content

SIlver Layer - Additional Columns

POWERBI Subscription

FnO-812: Need to enable additional

PowerBI Workspaces

date/time addition

Column 1	Column 2
10	10
20	30(10+20)
15	45(30+15)
25	70(45+25)