Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

WBS issue in Power Query - cannot change type to text

Hi everyone,   I have to do some analysis on the scheduele and I'm having trouble with the WBS column. When I import the csv (or excel), this column has a data type 'Any'. I noticed that majority o...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    Yes,if you directly change the type to text or use Text.From,you will get a result as below:

    You could try to take below steps：

    Click "Add column">"Column From examples">Using below format:

    And you will see:

    For my sample .pbix file,pls see attahched.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

I suspect that, on the Excel worksheet, the contents of row 2 is the result of a formula and not merely entered into the table as 17.1   Because of how Excel computes and stores fractional values, that is likely how the value is stored in Excel.  Hence the conversion you see in PQ.

 

How are those values actually generated in Excel?