Forum Discussion
Solved
Days Since
Hi I am creating a dashboard for a Service Desk We receive requests and now and then they can stay open for long. I am looking to create a column to show me some Day Ranges I created a C...
- Aging = sWITCH(TRUE(),'Aged_Weekly_QA_Report'[Days Since] < 20, "<20 Days",'Aged_Weekly_QA_Report'[Days Since] >= 30 && 'Aged_Weekly_QA_Report'[Days Since] <= 60, "30-60 Days",'Aged_Weekly_QA_Report'[Days Since] > 90, "90+ Days","Other")
Aging = sWITCH(
TRUE(),
'Aged_Weekly_QA_Report'[Days Since] < 20, "<20 Days",
'Aged_Weekly_QA_Report'[Days Since] >= 30 && 'Aged_Weekly_QA_Report'[Days Since] <= 60, "30-60 Days",
'Aged_Weekly_QA_Report'[Days Since] > 90, "90+ Days",
"Other"
)