Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

how to change column into mixed data type

Hi Community,   I'm wondering if its possible to change a column data type to be mixed - both text and numerical.  Looking at the image below, when I initially load the data file into PowerBI, some...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    In general you should NEVER load date that have dual types, that being said you can do it by pressing the icon "1.2", change the type to be anything i.e. Text. Then you should see the following line in the formula bar

    = Table.TransformColumnTypes(#"PrevStep",{{"Column Name", type text}})

     

    then just change the type text to type any

     

    = Table.TransformColumnTypes(#"PrevStep",{{"Column Name", type any}})

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

In general you should NEVER load date that have dual types, that being said you can do it by pressing the icon "1.2", change the type to be anything i.e. Text. Then you should see the following line in the formula bar

= Table.TransformColumnTypes(#"PrevStep",{{"Column Name", type text}})

 

then just change the type text to type any

 

= Table.TransformColumnTypes(#"PrevStep",{{"Column Name", type any}})

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks!