Forum Discussion
HugoJesus
Helper IV
6 years agoCumulative Using Summarized Table
Hello everyone, First of all, I'll explain what I'm trying to do. 1. Create a Summarized Table with the following columns "Calendar", "Created Tickets", "Closed Tickets", "Daily Open Tickets" (...
- 6 years ago
Hi, HugoJesus
Try to modify the formula as below:
... ..... VAR LastDay = MAX ( Date_Link[Calendar] ) VAR TempTable2 = ADDCOLUMNS ( TempTable, "Open_Tickets", var _date = [Calendar] return SUMX( FILTER( TempTable, [Calendar]<=_date ), [Daily_Open_Tickets] ) ) RETURN TempTable2The result will show as below:
Please check the attached pbix file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
darentengmfs
Post Prodigy
6 years agoHi HugoJesus
Please take a look at the following thread: https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115
- HugoJesus6 years ago
Helper IV
Hi Darentengmfs,
I've already saw that, but is not the same example, because I'm using SUMMARIZE instead of the primary table.Regards
Hugo Jesus