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.
Hello Power BI enthusiast,
I would like to calculate the time difference between two date/time data type. I have used the dax function of DATEDIFF as shown below but I think the precision is not correct
When I checked using online calculator, I got the correct value of time difference . Is there any other way to write DAX in order to get the correct precision value ?
Solved! Go to Solution.
Try this dax.
Hi @Anonymous
Hi @Anonymous
try without .[Date]. it cut datetime to only Date
= datediff(V_Incident[Created].[Date];V_Incident[Updated].[Date];SECOND)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Try this dax.
Hi @Anonymous
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |