Forum Discussion

gaikwadaa123's avatar
gaikwadaa123
Helper II
5 years ago
Solved

Date and Hour ending columns

I have below data 

 

I want to combine these to columns in order to get the correct DateTime column. Can anyone help me with this?

Thank you.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Try the following calculated column 


     

    Date/hour = 

VAR __date = LEFT(MAX('Table'[ForecastDate]),9)
VAR __hour = CONVERT('Table'[ForecastHour], STRING) & ":00"
Return 
__date & " " & __hour

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Try the following calculated column 


     

    Date/hour = 

VAR __date = LEFT(MAX('Table'[ForecastDate]),9)
VAR __hour = CONVERT('Table'[ForecastHour], STRING) & ":00"
Return 
__date & " " & __hour