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 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 a todos necesito cambiar el horario de las fechas en mis bases de datos, en las cuales si no estan dentro del horario laboral que es de (10:00:00 a17:00:00) cambie la hora a las 10:00:00. Ya que nose como modificar este campo.
Por ejemplo si es 21/05/2021 05:35:20 quiero cambiar ese campo al siguiente 21/05/2021 10:00:00.
Solved! Go to Solution.
@matihernandez94
Add the following calculated column to your table
New Date and Time = INT(Table[Date]) + TIME(10,0,0)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
thanks ,
but in the editor of power query the funcion "int" is not available
how i can do that ? 😞
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@matihernandez94
Add the following calculated column to your table
New Date and Time = INT(Table[Date]) + TIME(10,0,0)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks bro !
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 |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |