Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Try
SELECTEDVALUE ( Table[Date] ) + SELECTEDVALUE ( Table[Time] )
Thank you. Giving it a shot. Much appreciated.
Bit late but try adding the date to the time...
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |