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.
I need that when 'operation_external_id' = "602" appears on the timeline, that 'total_costs' accumulate considering 'calendar_date' and 'project_id'.
I need a sum conditioned on two variables:
1st when "602" appears in 'operation_external_id'
2nd when 1st accumulate 'total_costs' until date before '602' occurs
My data is as follows:
dim_operation_date: 'calendar_date'
dim_stand: 'projetc_id'
dim_operation: 'operation_external_id'
fact_followups: 'total_costs'
I need this result when find 'operation_external_id' = "602", give me the sum 259.65 + 3028 + 592.87 + 1660.42 + 5775.35 + 1233.12 + 975.53 + 281.02 + 1060.54 + 4226.68 + 328.57 = 19421.75
@andersonramos
Cumulative total =
CALCULATE (
SUM ( 'Table'[total_cost] ),
FILTER ( 'Table', [calendar_date] <= EARLIER ( 'Table'[calendar_date] ) )
)
Paul
Best
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please refer.
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Also, you can try a quick measure. You have an option for category subtotal. Right-click on table or field you will get an option.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Tks, but It didn't work, I need a sum conditioned on two variables:
1st when "602" appears in 'operation_external_id'
2nd when 1st accumulate 'total_costs' until date before '602' occurs
@andersonramos
Can you show us how does it look like after using the formula?
And It is appreciated if you can show your the your expected result in a table view, or just provide your pbix after removing sensitive infomation.
Best,
Paul
Of course, thanks for your interest
Follow link below:
https://docs.google.com/spreadsheets/d/19Vy6tx7RQzEmiLG1-CHYVwS2lUGGcQvpi6wvHghXZcI/edit?usp=sharing
I also have the pbix if needed.
Cumulative total =
CALCULATE (
SUM ( 'Table'[total_costs] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[stand_id] ),
[calendar_date] < EARLIER ( 'Table'[calendar_date] )
)
)
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |