Forum Discussion

Nazeem81's avatar
Nazeem81
Icon for Helper I rankHelper I
8 years ago

Values time duration not coming correctly

i,   I have an excel file with time duration date per sales person, but when I import the excelfile to power BI and change the time duration to data type time, the values for time duration between ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Nazeem81,

 

In my test, the time value is not changed after loading into Power BI desktop.

 

In your scenario, please check whether the data coming is correct in Query Editor mode. I think the wrong time duration displayed in visual is returned by your formula.

 

Below is my test, please have a look at.

Duration = HOUR ( Test5[Time] )&":"&MINUTE(Test5[Time])&":"&SECOND(Test5[Time])

 

Best regards,

Yuliana Gu

Nazeem81's avatar
Nazeem81
Icon for Helper I rankHelper I
8 years ago

HI v-yulgu-msft,

 

I noticed that in the query editor the time duration is with decimals.  See picture below. When I use my calculated measure in the report view the value is not coming correct due to the decimal issue. How can I solve this?