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.
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" (Is the difference between "Created Tickets" - "Closed Tickets") and finnaly "Open Tickets" (Cumulative of Daily Open Tickets).
2. Then to create cumulative, I'm using the before summarized table to do that, but is only returning the same value "39".
There's an example:
The DAX that I'm using:
Solved! Go to Solution.
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
TempTable2
The 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.
@HugoJesus , In your script of addcolumns .
"Open_Tickets",
CALCULATE
(
SUMX(Filter(TempTable,Date_Link[Calendar] <= earlier(Date_Link[Calendar])),[Daily_Open_Tickets])
)
new column =SUMX(Filter(Total_Open_Tickets ,[Calendar] <= earlier([Calendar])),[Daily_Open_Tickets])
Sorry, is not working. Give to me the follow error.
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
TempTable2
The 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.
Hi @v-easonf-msft,
It is possible to create a Variable, with this code and create x-axis visualizations by date?
Regard's
Hugo Jesus
Sorry the correct term is "Measure" instead of "Variable".
Hi @v-easonf-msft ,
This is a different level and my idea is to have the "Open_Tickets" in Area Chart by date.
The code that I'm using is the same that you have sent before, but a little different at the end.
Create a Measure:
Any idea how to solve this.
Regard's
Hugo Jesus
Anyone have an idea about this?
Help ...
Regards
Hugo Jesus
Hi @v-easonf-msft ,
That's a miracle, I searched in many sites, but no one have mentioned something like this.
It works perfectly, this is why I love to share my doubts here in this forum.
Thanks a lot.
Regard's
Hugo Jesus
Hi @HugoJesus
Please take a look at the following thread: https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115
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
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |