Forum Discussion

leonmholt's avatar
leonmholt
New Member
7 years ago
Solved

Reading different data types in the same table from Excel

Hi there, I am a new PBI user and have, so far, been able to find answers to any query I had but have not yet cracked this one. I have an Excel table which outputs different types of data on each ro...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    leonmholt 

     

    Excel handles a different data type for each cell, whereas DAX handles a single data type for each column. You may try using FORMAT.

    Column =
FORMAT ( Table1[Data], IF ( Table1[Data] > 1, "General Number", "Percent" ) )
Thejeswar's avatar
Thejeswar
Super User
7 years ago

Hi leonmholt ,

The Error that you get says that your column is of the format text. This gives error when you use a comparator operator with it.

In other words, your data column is a text. Hence data > 1 gives you error as you cannot compare a text column to a number.

Check if your data column is of text data type. If so make it a Number.

That should fix this

 

Regards.

Thejeswar

  • leonmholt's avatar
    leonmholt
    New Member
    7 years ago

    Hi Thejeswar ,

    Thanks for the assistance, I went into 'Query Editor' and, after a few 'trial and errors', changed the data type to "Fixed Decimal Number" then ran the data through v-chuncz-msft 's formula again and it worked!

    Many thanks! :smileyhappy:

    Léon