Specific group of dates as a metric

[Theasianmenace]

Hi Community!

I'd like to ask if it is possible for you to group custom dates for an evaluation metric.

Value: A range of dates in March

How many days it takes to do a given task.

For example:

1. 0-5 days
2. 6-10 days
3. 11-15 days
4. 16-30 days
5. 31-60 days

I've worked on trying to group with a DAX calendar or using filtered slicers, but I would like to ask if anyone can provide a more robust solution.

Many thanks!

[Anonymous]

Just to first clarify.  Is your grouping to do with the turn around time of the task itself?  I.e. is it independant of the date it completes and is all about having your value fall into a group based on the End-Date minus the Start-Date?

If so, create a column which is the TurnAround Time (TAT) in days.  Next create another column with a SWITCH condition that does the check of the TAT result and then records on of the string groups you had listed.