Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |