Need help power BI, running total by project and date

[jaygtt]

Hi,

I'm trying to calculate 2 running total colums for my business report on Power BI

1. Running total by project and date

2. Running total by date (all projects or the one filtered)

Here's an exemple on Excel (red colums):

Thanks !

[v-qiuyu-msft · Accepted solution]

Hi @jaygtt,

In your scenario, you can go to Query Editor, create a Index column from 1, 

Then create calculated columns below: 

Project comul = CALCULATE(SUM(Table1[Revenues]),FILTER('Table1','Table1'[Project]=EARLIER(Table1[Project]) && 'Table1'[Date]<=EARLIER(Table1[Date])))

Division cumul = CALCULATE(SUM('Table1'[Project comul]),FILTER('Table1','Table1'[Index]<=EARLIER(Table1[Index])))

Best Regards,
Qiuyun Yu 

[jaygtt]

Thank you for the help !

[jaygtt]

Anyone ?