Adding Units To Calculated Column

[slounsbury]

This is probalby a super easy solutions to this but after trying several different methods from the forum I couldn't get it to work. I have several columns that I need to either have time units added to them (ie. Hour, Day, Minute).

Here is an example of one of my columns that needs to have the "Days" unit added:

ART = ABS(DATEDIFF(v_rpt_Service_SLA[Date_Responded_UTC], v_rpt_Service_SLA[ART_ST],HOUR))

[Anonymous]

Hi

Could you please make the question clear ?  OR Can you please post some details / sample with what do you have and what do you expect?

Thanks
Raj

[slounsbury]

Of course, I have all three of these columns of which the last one I created through a DATEDIFF calculation as shown above. Currently It looks like this:

Date_Responded_UTC	ART_ST	ART
11/6/17 8:00 PM	11/7/17 8:00 PM	1
11/7/17 8:00 PM	11/11/17 8:00 PM	4

I am wanting it to look like this:

Date_Responded_UTC	ART_ST	ART
11/6/17 8:00 PM	11/7/17 8:00 PM	1 Days
11/7/17 8:00 PM	11/11/17 8:00 PM	4 Days

[Anonymous · Accepted solution]

Am not sure this is what you expect ....Please let me know if you need something else  🙂

Adding & "Days" at the end of your formula will solve the problem.

ART = ABS(DATEDIFF(v_rpt_Service_SLA[Date_Responded_UTC], v_rpt_Service_SLA[ART_ST],HOUR)) & "Days"

Thanks

Raj

[slounsbury]

Thank you @Anonymous, This worked great! I had been trying to place the & "Date" inside the parenthesis.