Forum Discussion
Solved
DAX formula for Monthly Cumulative Backlog Ticket Calculation
Hello, i have found a response in regards of the calculation of Monthly backlog and I m trying to implement a similar measure on my Power BI reports and i think the method described of solving the p...
Hi Yiannis_N
First, you need a column to calculate Open_Tickets minus Close_Tickets:
Column = [Opened_Tickets] - [Closed_Tickets]Then you can use the following dax to get the result you want:
Measure = var select_date = SELECTEDVALUE('Table'[Year]) RETURN SELECTEDVALUE('Table'[Column])+SUMX(FILTER(ALL('Table'),'Table'[Year]<select_date),'Table'[Column])Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yiannis_N
First, you need a column to calculate Open_Tickets minus Close_Tickets:
Column = [Opened_Tickets] - [Closed_Tickets]
Then you can use the following dax to get the result you want:
Measure =
var select_date = SELECTEDVALUE('Table'[Year])
RETURN
SELECTEDVALUE('Table'[Column])+SUMX(FILTER(ALL('Table'),'Table'[Year]<select_date),'Table'[Column])
Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.