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))
This does work for the date piece. I tried using Time.From([Hour]), but I'm getting an error on everything less than 10. Is it a formatting issue?
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))