need to calculate date difference in hours based on text condition

[murali5431]

Hi,

I have a column "Mode" which has multiple values; A, B, C & D. I need to calculate date difference in days, as per below condition:

If Mode = "A" or "B" , calculate ([Date1] - [Date2]), else

If Mode = "C" or "D" calculate ([Date3] - [Date4])

Please help.

Thanks,

Muralidhar

[Fowmy · Accepted solution]

@murali5431 

Add the following as a column,

New Column = 

IF ( [Mode] = "A" || [Mode] = "B", DATEDIFF([Date1] , [Date2],DAY), IF( [Mode] = "C" || [Mode] = "D",DATEDIFF([Date3] , [Date4],DAY)))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

[amitchandak · Accepted solution]

@murali5431 , Try like

Switch (true(),
[Mode] in { "A" ,"B"}, datediff([Date1],[Date2],day),
[Mode] in { "C" ,"D"}, datediff([Date3] , [Date4],DAY)
)

[murali5431]

Thank you @amitchandak !!

[Fowmy · Accepted solution]

@murali5431 

Add the following as a column,

New Column = 

IF ( [Mode] = "A" || [Mode] = "B", DATEDIFF([Date1] , [Date2],DAY), IF( [Mode] = "C" || [Mode] = "D",DATEDIFF([Date3] , [Date4],DAY)))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

[murali5431]

Thank you @Fowmy .. It worked!