Report ticket opened within 30 days of hire date

[davidthegnome]

Hello,

I am trying to calculate the number of tickets users have opened within 30 days of their hire date. I have a date column with the hire date and one with the ticket numbers (set to show as a count). Each user has a different hire date, so I can't use a filter for relative to today.

How can I filter the count of tickets per user relative to their individual hire date?

Thank you in advance.

[Anonymous · Accepted solution]

Can you try this?

CALCULATE(COUNT(Tickts[Tkt_no]),DATEADD(Dates[Date],-30,DAY)

Depenns on you data, you may need to use SUM.

CALCULATE(SUM(Tickts[Tkt_no]),DATEADD(Dates[Date],-30,DAY)

Thanks

Raj

[davidthegnome]

Hello,

I am trying to calculate the number of tickets users have opened within 30 days of their hire date. I have a date column with the hire date and one with the ticket numbers (set to show as a count). Each user has a different hire date, so I can't use a filter for relative to today.

How can I filter the count of tickets per user relative to their individual hire date?

Thank you in advance.