cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

LOOKUPVALUE doesnt support values of type integer with type text

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

7 REPLIES 7
Highlighted
Helper V
Helper V

Re: LOOKUPVALUE doesnt support values of type integer with type text

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.

Highlighted
Helper I
Helper I

Re: LOOKUPVALUE doesnt support values of type integer with type text

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

Highlighted
Helper V
Helper V

Re: LOOKUPVALUE doesnt support values of type integer with type text

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

 

Captura3.PNG

Highlighted
Helper I
Helper I

Re: LOOKUPVALUE doesnt support values of type integer with type text

jason.PNGmaterial.PNGproduct code.PNG                                        

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

Highlighted
Helper V
Helper V

Re: LOOKUPVALUE doesnt support values of type integer with type text

Change this to a data type number: 

 

Captura.PNG

Highlighted
Helper I
Helper I

Re: LOOKUPVALUE doesnt support values of type integer with type text

It doesnt allow that

Highlighted
Helper V
Helper V

Re: LOOKUPVALUE doesnt support values of type integer with type text

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

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors