cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jaygtt Frequent Visitor
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):

Captddure.JPGThanks !

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator 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, 

 

w1.PNG

 

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])))

 

w2.PNG

 

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
Frequent Visitor

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

Anyone ?

Moderator 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, 

 

w1.PNG

 

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])))

 

w2.PNG

 

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
Frequent Visitor

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

Thank you for the help !