Forum Discussion
Create a Timestamp from multiple columns in power query
Hello, I'm relatively new to Power BI. I am pulling in data from an API source, which separates out date and time into multiple columns. The data looks like this... Year Month Day Hour ...
you can just concatenate the time-value with the date-value like so:
DateTime.From(#date([Year],[Month],[Day]) & #time([Hour],0,0))
Hi Anonymous ,
I have tried changing the data type, etc. Time to call for the Magician of M. ImkeF
Nathaniel
you can just concatenate the time-value with the date-value like so:
DateTime.From(#date([Year],[Month],[Day]) & #time([Hour],0,0))