Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Solved! Go to 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
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
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 |
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
Thank you @Anonymous, This worked great! I had been trying to place the & "Date" inside the parenthesis.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |