How to get assignee for particular period(eg. Last Month,Last Year)

Questions & Answers
, ,
3

Hi @Tamil,

You could use a similar approach as described in this post: How to list all assignees of an issue - #2 by zane.baranovska. I adopted the formula to show all assignees during the selected period for issues that had assignee changes:

Issues_-__sandbox-_eazyBI
Issues_-__sandbox-_eazyBI1560×638 55.6 KB

Here is the formula:

Generate(
  --go through all Assignee users
  Filter(
    [Assignee].[User].Members,
    --check wheather user was assignee of the issue during selected period
    NOT IsEmpty([Measures].[Issues history]) ),
  --get assignee names separated by comma
  [Assignee].CurrentMember.Name,
  ","
)

Lauma / support@eazybi.com