Forum Discussion

boclifton's avatar
boclifton
Regular Visitor
9 years ago
Solved

Burndown chart for data progress

I've found a few instances of using a burndown chart in TFS and Scrum settings, but my team has an existing report in SSRS that I'm trying to remodel in Power BI that utilizes a burndown chart for pr...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi boclifton,

     

    You can try to use below formulas to get the remain item and bytes.

     

    Measures:

    Remain Items =
    var currProject=LASTNONBLANK(Table[ProjectID],[ProjectID])
    var TotalItem=SUMX(FILTER(ALL(Table),Table[ProjectID]=currProject),[TransactionItemsMigrated]) + MAX(Table[CurrentItemFailed]) //total items + failed items
    return
    TotalItem-SUMX(FILTER(ALL(Table),Table[ProjectID]=currProject&&Table[Date]<=MAX(Table[Date])),[TransactionItemsMigrated])

     

    Remain Bytes =

    var currProject=LASTNONBLANK(Table[ProjectID],[ProjectID])
    var TotalBytes=SUMX(FILTER(ALL(Table),Table[ProjectID]=currProject),[TransactionSizeBytes])
    return
    TotalBytes-SUMX(FILTER(ALL(Table),Table[ProjectID]=currProject&&Table[Date]<=MAX(Table[Date])),[TransactionSizeBytes])

     

    Regards,

    Xiaoxin Sheng