- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data changing from excel
Hi,
When i import the data shown here
it changes to this
When i try to transform the last coloumn to duration, i get an error.
Would someone be able to talk me through a soloution please?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Heya,
You have to properly format the column in Power Query (Transform data) when importing the Excel. I did the same table and imported it in PBI and got the below result:
However, I don't knwo what you're trying to achieve but the difference between those dates/times should be 1 Day and 3:06:20
If this solved your problem then please mark it as the solution so others can see it.
Cheers
If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi MNedix ,thanks for the quick reply, I'll add more.
Hi @sharpiejas ,
Regarding your question, look at the steps in your Power Query and see if there is a 'Change Type' that changes the data type to a number.
Best Regards,
Wenbin Zhou
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Heya,
You have to properly format the column in Power Query (Transform data) when importing the Excel. I did the same table and imported it in PBI and got the below result:
However, I don't knwo what you're trying to achieve but the difference between those dates/times should be 1 Day and 3:06:20
If this solved your problem then please mark it as the solution so others can see it.
Cheers
If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-05-2024 08:56 AM | |||
06-17-2024 08:13 AM | |||
06-02-2024 08:03 PM | |||
07-24-2024 06:06 AM | |||
12-21-2017 11:38 AM |
User | Count |
---|---|
117 | |
99 | |
84 | |
53 | |
47 |