Conditional calculation with different unit of measure

[Anonymous]

Hi,

Can anyone help me achieve the below? 

I have these columns in PBi:

Case | Latest comment date | Case type 

1 | 03-18-2022 09:56:36 AM | A 

2 | 03-19-2022 15:35:23 PM | B 

3 | 03-21-2022 20:31:05 PM | C 

For case type A I would like to calculate how many hours have passed since the comment was placed till now.

For case type B and C I would like to calculate how many days have passed since the comment was placed till now.

My desired output is:

Case | Latest comment date | Case type | Passed

1 | 03-18-2022 09:56:36 AM | A |  80 hours

2 | 03-19-2022 15:35:23 PM | B | 2 days

3 | 03-20-2022 20:31:05 PM | C | 1 day

Appreciate your help!

[Anonymous]

Thank you John!

[johnt75 · Accepted solution]

You could add a calculated column as

Passed =
IF( 'Table'[Case type] = "A", DATEDIFF( 'Table'[Latest comment date], NOW(), HOUR) & " hours",
   DATEDIFF( 'Table'[Case type], NOW(), DAY) & " days"
)

or if you want to put it in a measure you would need to wrap the column references in SELECTEDVALUES functions