Forum Discussion

sharpiejas's avatar
sharpiejas
New Member
1 year ago
Solved

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 sol...
  • MNedix's avatar
    MNedix
    1 year ago

    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

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
1 year ago

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