Adding date and time fields in formula

[DrewCarousel]

Dear community,

I have a complicated if and else formulated column where one of the ifs says:

... else if column A <> null then Column B + Column C else...

where column B is a date time field and column C is a time field. 

I have tried various solutions found online but none of them seem to have worked (using +, using &" "& and then formatting the column, using date(...)&time(...) )

Help please!

[Anonymous · Accepted solution]

Hi  @DrewCarousel ,

You can consider using Dax to achieve:

Here are the steps you can follow：

1. Create measure.

Measure =
 IF(
    MAX('Table'[ColumnA]) <> BLANK(),FORMAT(MAX('Table'[ColumnB]),"yyyy-mm-dd"),FORMAT(MAX('Table'[ColumnC]),"hh:nn:ss AMPM"))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[bcdobbs]

You could pass the year, month, day, hours, minutes etc into:

DATE(2015,1,9) + TIME(2,30,0)

Since August 2021 you can use string literals but wonder if you're using an old version?

https://docs.microsoft.com/en-us/dax/dax-syntax-reference#date-and-time