Combined Datetime column from separate Date & Time

[Medmbchr]

Hi,

I have a column in which I would like to display the following: 01/01/2022 18:00:00

This value should come from:

- A column: 01/01/2022 00:00:00

- A measure: 18:00:00 (which I made using mymeasure=TIME(HH,MM,SS)

When I do DATETIME(mycolumn&" "&mymeasure) it gives me 01/01/2022 00:00:00 without taking into consideration the time value.

Any idea how to combine these two?

[DataInsights · Accepted solution]

@Medmbchr,

Try adding them together instead of concatenating.