Forum Discussion

Yiannis_N's avatar
Yiannis_N
Frequent Visitor
2 years ago
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...
Backlog
Calculated Measures
DAX
power bi
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523