Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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? 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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? 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

No creating caluclations or measures won't affect the datatype of the column until it is chnaged explicitly.

 

Thanks,

Pragati