Forum Discussion
rohitchouhan
6 years agoFrequent Visitor
Addition in powerBI
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 ...
vivran22
Community Champion
6 years agoHello rohitchouhan ,
You may try this:
Running Total =
VAR _Current = 'Table'[Index]
VAR _Filter =
FILTER(
'Table',
'Table'[Index] <= _Current)
VAR _Sum =
CALCULATE(
SUM('Table'[Column 1]),
_Filter)
RETURN
_Sum
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:
Cheers!
Vivek
If 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-blog
Connect on LinkedIn
Follow on Twitter