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? 

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

HI Anonymous ,

 

Can you click on your column on the FILEDS pane ansd check what data format it has got on the top ribbon as shown below:

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

 

I use Russian version 

In Data Type and Format - its Whole Number, in Summarization its Sum