Forum Discussion

telesforo1969's avatar
telesforo1969
Helper V
10 months ago

Create a date-time field from a date column and a number column with the time in "DirectQuery Mode"

  I need help joining two columns, one containing values ​​in date format and the other containing the time in number format in DirectQuery mode.  
Need Help
Omid_Motamedise's avatar
Omid_Motamedise
Super User
10 months ago

Hi,

You can add a new column using the following formula

 [Fecha]& #time([Hora],0,0)

for detail see the attached file

 

 

  • telesforo1969's avatar
    telesforo1969
    Helper V
    10 months ago

    Thank you very much, but I am connected in DirectQuery mode and it does not allow the transformation; it asks me to switch to Import mode.

  • telesforo1969's avatar
    telesforo1969
    Helper V
    10 months ago

    Thank you very much, but I am connected in DirectQuery mode and it does not allow the transformation; it asks me to switch to Import mode.