Forum Discussion
Convert Measure Text type into Date-Time Type
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 typ...
Hi Anonymous,
Here is the required DAX.
DateTime =
DATEVALUE (
SELECTEDVALUE ( Table[Date] ) & " " & SELECTEDVALUE ( Table[Time] )
)Enjoy !!
Prateek Raina
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.