Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cumulative backlog

Dear all,
 
I have create this measure and it's doesn't work :
Backlog = CALCULATE([Balance];FILTER(all('Date');'Date'[Date]<=MAX('Date'[Date])))
 
Result = 
 
 
Ps : Balance measure = Created(backlog) - Resolved(backlog) 
 
 
Can you help me please ? 
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks for your answer but I already resolve the issue. It was link to the data type of my date columns, I had just to change data types in Power BI Query ! 

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous based on info you provided, in yur table if you use [date] from date table instead of [creation week] from your tran table, it will work.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      No, it's doesn't work : 

      Created (backlog) = COUNTA(export_incident[Opened])
       
      Resolved (backlog) = CALCULATE(COUNTA(export_incident[Resolved]);USERELATIONSHIP('Date'[Date];export_incident[Resolved]))
       
      Balance = [Created (backlog)]-[Resolved (backlog)]
       
      My model : 
  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Please try to use the formula as below. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

    Backlog = SUMX(FILTER(all('Date');'Date'[Date]<=MAX('Date'[Date]));[Balance])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for your answer but I already resolve the issue. It was link to the data type of my date columns, I had just to change data types in Power BI Query !