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.
Hi,
I'm trying to calculate DATEDIFF but getting weird results... I would like to see in "Column" 1.5, 1.5, 2, 1.5 etc.
I'll appreciate your help with that.
Thanks!
Solved! Go to Solution.
Hi @shainis
A few questions:
Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?
Is what you want to calculate a column or a measure?
In the meantime, try this instead:
([EndDate] - [EventDate]) * 24
which should yield the difference in hours
Hi @shainis
A few questions:
Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?
Is what you want to calculate a column or a measure?
In the meantime, try this instead:
([EndDate] - [EventDate]) * 24
which should yield the difference in hours
Thanks, @AlB, that worked!
An alternative solution would be to use the Time Subtruct. Both are doing the job.
Thank you!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |