Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Data Type duration

I have a duration column in excel, what data type should i use when import into power bi?  it's all 'Error' when i select 'duration' in power bi.     
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi there, you would have to change it to Text, due to it having the ":" which is seen as text.

     

    What I would suggest is if you want to calculate the duration in Power BI is to have the Source Date Time in order to do this, can modify it all to be seconds. Then from there you can then roll it up to Hours, Days etc.

     

    Here is another link referencing how they did it with Date and Times

    http://community.powerbi.com/t5/Desktop/Sum-of-H-MM-SS/m-p/124007 

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi there, you would have to change it to Text, due to it having the ":" which is seen as text.

 

What I would suggest is if you want to calculate the duration in Power BI is to have the Source Date Time in order to do this, can modify it all to be seconds. Then from there you can then roll it up to Hours, Days etc.

 

Here is another link referencing how they did it with Date and Times

http://community.powerbi.com/t5/Desktop/Sum-of-H-MM-SS/m-p/124007 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Your link is invalid.