Overlaps per month

Hi Patrick_BT ,

 

You'll need to create a calendar dimension table. There's plenty of examples online either in DAX or Power Query (recommended). Your calendar table will need at leaste Date and Month/Year (MM.yyyy).

 

Once you have that, the basic measure structure for your counts would be something like this:

 

_openTickets =
VAR __maxDate = MAX(calendar[date])
VAR __minDate = MIN(calendar[date])
RETURN
CALCULATE(
  DISTINCTCOUNT(yourTable[TicketID]),
  yourTable[Priority] = "Blocker",
  FILTER(
    yourTable,
    yourTable[Created] <= __maxDate
    && yourTable[Resolved] >= __minDate
  )
)

 

 

Use calendar[YearMonth] and [_openTickets] in your visual.

 

Pete