Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] )
)
)
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |