cancel
Showing results for
Did you mean:
Highlighted
jaygtt Frequent Visitor

## Need help power BI, running total by project and date

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 !

1 ACCEPTED SOLUTION

Accepted Solutions v-qiuyu-msft
Moderator

## Re: Need help power BI, running total by project and date

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
jaygtt Frequent Visitor

## Re: Need help power BI, running total by project and date

Anyone ? v-qiuyu-msft
Moderator

## Re: Need help power BI, running total by project and date

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jaygtt Frequent Visitor

## Re: Need help power BI, running total by project and date

Thank you for the help !