Forum Discussion

matihernandez94's avatar
matihernandez94
Frequent Visitor
5 years ago
Solved

set hours

hi everyone,    i need to set the hours of dates, for example if the day is 21/05/2021 05:35:20 i want change to 21/05/2021 10:00:00. And that for a lot of dates, always with the 10:00:00.   Hola...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    matihernandez94 

    Add the following calculated column to your table

     

    New Date and Time = INT(Table[Date]) + TIME(10,0,0)

     

     

matihernandez94's avatar
matihernandez94
Frequent Visitor
5 years ago

thanks , 

but in the editor of power query the funcion "int"  is not available

 

 

 

how i can do that ? šŸ˜ž 

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    matihernandez94 

    I thought you wanted a solution as a Calculated Column in the model. No issue, Please use the add custom column in Power Query and use the following code.