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.
Hi Team,
Could you please help me to write a dax to combine date column and time column into datetime column.
I applied Different dax functions but i am not getting proper formate
For Example
1) Date column(dd-mm-yyyy) and datatype is date
2) Time column(hh:mm:ss) and datatype is time
3) After combine Date column and Time column i am getting below
DateTime
03-11-2019 07:38:22 |
19-12-2017 05:30:00 |
In the above table one value(MM-DD-YYYY hh:mm:ss) and second value(DD-MM-YYYY hh:mm:ss)
Any one please help me on this and this is very urgent issue.
There are a few ways. But this what I think will work most of the time
Date in dd/mm/YYYY format
Time in hh24:mi:ss format
I create two formula and marked that as date time
Combine = mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4) & " "& DD__MM__YY[ time]
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
Thanks for your prompt response. I tried using the syntax you suggested but unfortunately it didn't help.
Instead of desired format (19-12-2017 05:30:00), your solution gave the following result: (19/12/2017 12/19/2017).
Out of many other trial and error process, I finally used the following syntax to get desired result:
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |