Forum Discussion
Datetime column in SQL Server not displayed the same type in Power BI
Hi ahmed_MEJRI ,
In query editor, select both of these columns, right click and MERGE.
This will merge both of these columns.
Then click on the merged column and chnage it's datatype to datetime format from the top ribbon under TRANSFORM.
Consider following example:
Select both of your columns Date and Time:
Right click and select MERGE as highlighted above.
A window appears, enter the following values:
Once you hit OK, you get the following:
Select your merged column - DateTime Value
Then click on Transform on top ribbon and modify datatype to DATETIME as shown below:
You get your merged Datetime column as shown:
Hope this helps.
Thanks,
Pragati
ahmed_MEJRI , this can not happen automatically as far as I know. Open Transform data mode and check if there is a step that split this column into two.
Also, change the data type of date column to DateTime. and choose a format where time is visible. and check do see any time other than 12:00:00 AM
Hi Experts,
in my model i have two columns called : Date and Heure (it's hour in french)
can we create a calculated column with DAX to make concat for the 2 columns Date and Heure to have the completed datetime and we call this column DatetimeFX for example ?
Best Regards
Hi ahmed_MEJRI ,
In query editor, select both of these columns, right click and MERGE.
This will merge both of these columns.
Then click on the merged column and chnage it's datatype to datetime format from the top ribbon under TRANSFORM.
Consider following example:
Select both of your columns Date and Time:
Right click and select MERGE as highlighted above.
A window appears, enter the following values:
Once you hit OK, you get the following:
Select your merged column - DateTime Value
Then click on Transform on top ribbon and modify datatype to DATETIME as shown below:
You get your merged Datetime column as shown:
Hope this helps.
Thanks,
Pragati