Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Solved! Go to 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
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
Thank you for the help !
Anyone ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |