Create a Filter from Calculated Column

[TapZxK]

Hi All, 

I have a calculated column that counts the difference in days between 2 dates columns. 

Days = 1. * 'Resolved Tasks'[Due Date] - 'Resolved Tasks'[Resolved]

 

I would like to create a filter now with following criteria.

"Resolved before due date"

"Resolved within 7 Days after due date"

"Resolved within 14 days after due date"

"Resolved later than 14 days after due date"

I would appreciate if someone could advise on what would be the best way for it to be done.

[TapZxK · Accepted solution]

Created Calculated column like so:

Filter = SWITCH(TRUE(),'Resolved Tasks'[Days] >= 0, "On Time",

'Resolved Tasks'[Days] < 0 && 'Resolved Tasks'[Days] >= -7, "Within 7 days after due date",

'Resolved Tasks'[Days] < -7 && 'Resolved Tasks'[Days] >= -14, "Within 14 days after due date",

'Resolved Tasks'[Days] < - 14, "Resolved later than 14 days after due date")