Forum Discussion
Duration wrongly converted to Date-Time type
I am getting data from an excel file which include a column which shows duration as mm:ss:ms But when I import the data to Power BI Desktop with Power Quey, it converts this column to date/...
I believe it is not going to work because if you look at the original column form the excel, there are milliseconds in the end, but after importing to power BI, it rounds up the milliseconds, and that doesn't make sense because it a competition these milliseconds actually matter.
BjoernSchaefer
Helper II
Helper IIHi Anonymous,
sorry, i missunterstood you. DAX cannot handle milliseconds. But i found something that'll may help you with that.
https://stackoverflow.com/questions/46833631/how-to-deal-with-milliseconds-in-powerbi
Regards
BjoernSchaefer