Forum Discussion

Marion's avatar
Marion
Frequent Visitor
4 years ago
Solved

[Expression.Error] We cannot convert the value 0 to type Text.

Hi

I am trying to import Excel files that display a number format ".00" in several columns.

I need to convert figures to format "0,00" in my PowerBI file so I can aggregate them.

I replaced "." with "," in each column and chose currency format.

The following error message persists :

[Expression.Error] We cannot convert the value 0 to type Text.

 

Thanks for your help

Need Help
  • Marion's avatar
    Marion
    4 years ago

    Hi Selimovd,

    I found the error. I was trying to change the format in a reference table, instead of changing the format in the source table... Thanks !

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Hey Marion ,

     

    can you make sure that there is no transformation in one of the first steps?

    Can you post a sample or example of your transformation?

     

    Best regards

    Denis

    • Marion's avatar
      Marion
      Frequent Visitor
      4 years ago

      Hi Selimovd,

      I found the error. I was trying to change the format in a reference table, instead of changing the format in the source table... Thanks !