Forum Discussion
Date 24hr clock
Is it possible to change the Datetime format to 24hrs clock in the query editor?
I.e 01/01/2020 2:00:00 pm to 01/01/2020 14:00:00
I was able to change the datetime format under the modeling tab using below formaula.
Call Start Time 24Hours = FORMAT(T3[Call Start Time],"MM/DD/YY HH:mm:ss")
However, I need to merge this column with another column and seems like I am not able to do it from the modeling tab and cannot find "call start time 24hours" column under query editor. (If there is a way please let me know). Is it possible to add a column from query editor to change the time format instead of from modeling tab?
Thanks,
Daven
- Hi Anonymous ,The calculated columns you create with DAX will not show up in "edit queries", which is the design principle of power bi.To merge two columns, you can use the "CONCATENATE" function to create a calculated column.Column = CONCATENATE(Sheet2[time],Sheet2[year_month])Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Hi Anonymous ,The calculated columns you create with DAX will not show up in "edit queries", which is the design principle of power bi.To merge two columns, you can use the "CONCATENATE" function to create a calculated column.Column = CONCATENATE(Sheet2[time],Sheet2[year_month])Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Anonymous
it absolutely doesn't matter how it looks like in Power QUery editor. In this mode data only STORE.
Use format in the report mode and DAX if you need
do not hesitate to give a kudo to useful posts and mark solutions as solution
