Forum Discussion
Conditional calculation with different unit of measure
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.
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!
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
2 Replies
johnt75Super User
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