Convert Measure Text type into Date-Time Type

[Anonymous]

I have written 2 measures which gives me date value and time value.

SelectedDate = SELECTEDVALUE(New[BEGIN_DATE])

SelectedTime = SELECTEDVALUE(DateRange[TimeRange])

these both data type is date and time.

But when i try to combine these both measure values as below

Selected Date-Time Range = [SelectedDate]&" "&[SelectedTime]

It is becoming type text and i cant even change the type to date-time(DD:MM:YYYY HH:MM:SS TT)

I tried with TRUNC function from here

https://www.sqlbi.com/blog/marco/2016/12/06/format-measures-as-dates-in-power-bi-dax-powerbi/

Selected Date-Time Range = TRUNC([SelectedDate]&" "&[SelectedTime])+DATE ( 1899, 12, 30 )

Well it is getting converted into date-time type but here im missing the time values

Can anyone please help to get this done.

Thanks You.

Mohan V

[johnt75]

Try

SELECTEDVALUE ( Table[Date] ) + SELECTEDVALUE ( Table[Time] )

[Anonymous]

Thank you. Giving it a shot. Much appreciated.

[uk_tj]

Bit late but try adding the date to the time...

[prateekraina]

Hi @Anonymous,

Here is the required DAX.

DateTime =
DATEVALUE (
    SELECTEDVALUE ( Table[Date] ) & " " & SELECTEDVALUE ( Table[Time] )
)

Enjoy !!

Prateek Raina

[Anonymous]

@prateekraina thanks for the reply

i tried this but didnt worked.

Selected Date-Time Range = 
DATEVALUE (
    SELECTEDVALUE ( New[BEGIN_DATE] ) & " " & SELECTEDVALUE(DateRange[TimeRange]))

Not giving the time value.

[prateekraina]

Hi @Anonymous,

Check out this short video. You can achieve this in the Power Query Editor itself.

No need for DAX measures.

Prateek Raina

[Anonymous]

Well thanks for the suggestion @prateekraina.

I know we can achive this by power query and DAX calculated column.

I have done that already.

But for my requirement, i have to go with the measures only.

If you have time then go with the detaield explantion of what im trying to achive

https://community.powerbi.com/t5/Desktop/How-to-create-Dynamic-Date-Time-Range/m-p/482159

Thanks,

Mohan V

[prateekraina]

HI @Anonymous,

This is some problem statement 🙂

Can you tell me what is the reason you want the concatenated column to have a DateTime data type and not Text?

Prateek Raina

[Anonymous]

Irrelevant. Just answer his question. That's what he needs. Why do you ask him to justify? Absurd. Either provide an answer or don't respond. Simple.