Christopher- The data looks fine in the attached workbook, however could you try something in your live connection? Convert the field "Hora" which is in "Measures" to "Dimension" and see if it makes any difference.
3 of 3 people found this helpful
This may not help, but what happens if you try something along the lines of:
DATEADD ( 'hour', INT ( [Hora] ), [Fecha] )
It feels like the division is problematic.
Also, can the [Hora] type be changed to whole numbers?
1 of 1 people found this helpful
I'm with swaroop. I guess instead of concatenating hours with date you may try with DATEADD() function.
Give a try and let us know if this help.
This worked. It was the division that was causing an issue. Why it worked on an Extract set and not on a Live connection, I have no idea.
Thank you for your quick response.
I adjusted Fecha to type datetime, and used your formula.