Lookupvalue error saying cannot compare text type with intg type but both columns are text type

[sarahspowerbi]

Lookupvalue error saying cannot compare text type with intg type but both columns are text type. I went to transform/power query and ran check data type and both state text. 

[parry2k]

@sarahspowerbi it is not about reversing, read the documents and the example and apply in your solution.

[sarahspowerbi]

If I try to reverse them, it does not give me the option to select a column from the Team Data Table, only San Fran Projects List data table. 

[parry2k]

@sarahspowerbi you are using wrong syntax, first column should be what value you want to return and 2nd two columns should be project name from the respective table, read more here LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️