Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert two datatypes in one column to one

Hi, I am relatively new to Power BI and am trying to convert two data types from one column to one. I have a column called ACD Time and some of the values are in time format(hh:mm:ss) and some of it ...
General Comment
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Click on custom Column and add the following code

    try Time.From(Number.From([123 AUX Time])) otherwise Time.From([123 AUX Time])

     

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks, It worked.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

Click on custom Column and add the following code

try Time.From(Number.From([123 AUX Time])) otherwise Time.From([123 AUX Time])