Forum Discussion
Convert Measure Text type into Date-Time Type
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.
Hi Anonymous,
Check out this short video. You can achieve this in the Power Query Editor itself.
No need for DAX measures.
Prateek Raina
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
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
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.