LOOKUPVALUE doesnt support values of type integer with type text

[dkehoe32]

Im using the LOOKUPVALUE function in order to fill this column but i keep getting this error.

[luxpbi]

Hi dkehoe32,

This is beacause one value is type text and the other is type int. What is the type of [Material]? If the change doen't afect your report, please consider to change the data type yo number and try again.

[dkehoe32]

the material is a number code but BI says its in text format and im unable to change it to number

[luxpbi]

Can you please send a photo of the material data type? 

[dkehoe32]

                                        

These are the 3 values for my LOOKUPVALUE and their data types

[luxpbi]

Change this to a data type number: 

[dkehoe32]

It doesnt allow that

[luxpbi]

Then I think that the problem is that you have in your [Material] Column data with both types, text and int.