Forum Discussion

tommasocitton's avatar
tommasocitton
Frequent Visitor
8 years ago
Solved

Another way to calculate backlog

Hi all, I'vre tried to search but all examples seems not to fit my needs... I've got two table: CALENDAR (classical virtual table with all dates in the last 2 years) INCIDENT_LOG ("n" rows per ...
  • tommasocitton's avatar
    tommasocitton
    8 years ago

    Of course!

    Thanks for the support you gave me! :)

     

    Tommaso

tommasocitton's avatar
tommasocitton
Frequent Visitor
8 years ago

Hi emadrigal.

I'm not so sure to understand what you mean.

Considering I'm quite a newbie in DAX, off course I suppose I can create a calculated table and filter it, but I'm not able to realize it in mind first.

I mean... the output should just be another table with the count per day of all tickets for which the last status (for date <= on observation date) is <> Closed. I've tried to make an example in sql-style.

emadrigal's avatar
emadrigal
Helper II
8 years ago

you need to create a calculated column using the calculate formula using a filter there., here is an example:

 

you could have this column on the calendar table or a new one because you want to count items per day.

Column = CALCULATE(COUNT(item[itemId]]),status <> 'closed')