Dashboards
Power Query
Power Pivot
Power BI
February 24, 2021
I've imported from the web data that displays date as 1 to 31 and time in the format 12.01 (the separator being '.' I want to transform the date to format 01/01/2023 to 31/12/2023 and time to format 12:01 This only seems to work if each cell is changed manually. Any solutions? Thanks
Moderators
January 31, 2022
Dashboards
Power Query
Power Pivot
Power BI
February 24, 2021
Moderators
January 31, 2022
Thanks for the file. Just wondering how you would know which month we are dealing with. Obviously, your example relates to January as that is what is written in the Sheet name. Will you always receive csv files with the name of the month in it?
And just to be sure, a time reference like 8.3 will be thirty minutes past 8, whereas 10.05 will be 5 minutes past 10. Correct?
Dashboards
Power Query
Power Pivot
Power BI
February 24, 2021
Hi Riny,
https://www.trggpattaya.com/schedule/
This is the link to the webpage. The new month is added to the website each month and identified only by the title January 2023, February 2023 etc
Time references are displayed on website as 08.30 10.05 etc. Importing them truncates zeros so 08:30 becomes 8.3
The file Raw Data I loaded it without transforming anything.
Thanks
Alistair
Moderators
January 31, 2022
1 Guest(s)