The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
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
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
User | Count |
---|---|
78 | |
77 | |
38 | |
31 | |
28 |
User | Count |
---|---|
106 | |
96 | |
55 | |
49 | |
46 |