Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good afternoon.
I need to convert a base that is connected to a sharepoint list with columns of start date, start time, end date, end time, all columns are as string and the biggest problem is as 24Hrs, that is, midnight time in base shows up as 24:00 and not 00:00.
Solved! Go to Solution.
@Anonymous , if this datetime field, You should be able to choose a format to display
Hi @Anonymous ,
As you mentioned——columns of start date, start time, end date, end time, all columns are as string
So please go to Power Query dialog and transform the columns to the correct types firstly.
Then you could choose the dispaly format as @amitchandak said.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , if this datetime field, You should be able to choose a format to display
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 |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |