The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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] )
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
56 |
User | Count |
---|---|
256 | |
120 | |
112 | |
83 | |
71 |