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" ) )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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" ) )
  • leonmholt's avatar
    leonmholt
    New Member
    7 years ago

    Hi v-chuncz-msft ,

    Many thanks for your suggestion, I have tried to use your methodology to achieve the desired output but am met with an error;

    "DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values."

    Any further assistance would be greatly appreciated.

    Many thanks,

    Léon