Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help convert text to data and convent number to data

hi,   i'm new here and this is my first post.   i imported from excel a db, but the format is not correct, and try to change a format but without success.   i have 2 problems with 2 different c...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

How exactly doesn't it work? Can you be specific about the error?

Thanks for the PBIX file but without your source Excel data I can't do anything.  I can open your query but I can't really work on it as I can't see the columsn or what your transformations steps are doing.

I can see that it looks like you've tried multiple ways to convert the column but I don't knwo what state the table is in at the end of all of these steps.

Can you please provide the file C:\profili\U399105\Desktop\POWER BI\V1\01_DB_GLOBALE.xlsx

If it has confidential info you can Prvate Message it to me.

regards

Phil

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PhilipTreacy  i send you a pm with excel

thanks for the infinite patience and the invaluable help