Simple Switch Statement GAP in Values

[v_mark]

I was trying to satisfy a requirement based on these parameters

Count of Transactions

less than 24 Hrs,

More than 72 Hrs and

More than 120 Hours

I created a calculated column Hours Difference by using datediff

Hours = DATEDIFF('Sample Data'[CreatedDateTime],NOW(),HOUR)

and create a tagging 

SLAs = SWITCH(TRUE(),

'Sample Data'[Hours] <= 24 , " Less than 24 Hrs ",

'Sample Data'[Hours] >= 72 , " More Than 72 Hrs ",

'Sample Data'[Hours] >= 120, " More Than 120 Hrs",

BLANK())

Which returns like 

My problem with this requirement is there is a gap there are some transactions that occur 25+ hours up to 71 hours. 
which is not covered in the requirement that was given.

Any chance of Specifying those in the actual measure? I was hoping to see those 120+ as well 
Workarounds are highly appreciated. TIA!

Sharing the sample PBIX  

[Anonymous]

Hi  @v_mark ,

Here are the steps you can follow：

1. Create calculated column.

SLAs =
SWITCH(TRUE(),
'Sample Data'[Hours] <= 24 ," Less than 24 Hrs ",
'Sample Data'[Hours] >= 72&&'Sample Data'[Hours]<120 ," More Than 72 Hrs ",
'Sample Data'[Hours] >= 120," More Than 120 Hrs",
BLANK())

2. If you don’t want to display blank data, you can turn off "Show items with no data".

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[mwegener · Accepted solution]

Hi @v_mark ,

try this

SLAs = SWITCH(TRUE(),
'Sample Data'[Hours] <= 24 , " Less than 24 Hrs ",
'Sample Data'[Hours] >= 120, " More Than 120 Hrs",
'Sample Data'[Hours] >= 72 , " More Than  72 Hrs ",
'Sample Data'[Hours] >= 25 , " More Than  25 Hrs ", 
BLANK())