Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Im using the LOOKUPVALUE function in order to fill this column but i keep getting this error.
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.
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.
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |