Im using the LOOKUPVALUE function in order to fill this column but i keep getting this error.
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.
the material is a number code but BI says its in text format and im unable to change it to number
Can you please send a photo of the material data type?
These are the 3 values for my LOOKUPVALUE and their data types
Change this to a data type number:
It doesnt allow that
Then I think that the problem is that you have in your [Material] Column data with both types, text and int.