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 a bunch of logs that I need to combine, each is a excel file with no tables and a bunch of timestamps. The timestamps are datetime in excel, the datevalue includes the date.
When I try to convert the column to datetime from text, the time is correct but the date is not.
It's showing as 12 April instead of 4 April.
Is there a way I can get it to reflect the datetime as per the Excel cell value?
These reports are in .xls format.
@Vijay_A_Verma - sorry not sure if I replied correctly.
Here is the column before transformation.
I'm using a workaround by appending the date to the filename via microsoft flow, then I leave start/end times as time with no date, and extract the date from the filename.
I then generate a time series with hours and minutes, join the start time on that, join the date on the calendar and it all comes together nicely.
Can you post the screenshot of Start Time column of PQ before converting to datetime?
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.