Forum Discussion
Data formatting - Numbers are identified as text
Hello everyone! I'm kinda new to PBI and stumbled across a problem that I have no idea how to solve. In query editor I have a table with column formats set to match the data types. Column "Сумма" f...
Created a new file and CopyPasted the full query to the new file.
Everything works fine.
The only difference is that I did not create any measures and did not create any calculation tables in Tabular Editor.
Could it possibly be one of the reasons for a glitch?
Fowmy
Super User
Super UserAnonymous
Possibly, it could be formatted as TEXT in the data model though you set the type as Number in Power Query. Please check.
If it doesn't work, make sure any subsequent steps in Power Query didn't change the type.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂