https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-use-lookupvalue-function-to-match-Sites-with-the-state/m-p/3409772#M128873 <P>thank you, even though one of the columns was integers, it was marked as text in the format. This is whats been messing me up, thank you again!</P> Thu, 31 Aug 2023 20:59:16 GMT adrianvandiver 2023-08-31T20:59:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-use-lookupvalue-function-to-match-Sites-with-the-state/m-p/3409563#M128855 <P>I have one query with sites with a unknown state, and another query with sites and states known. Im trying to use lookup to find the solution, but unfortunately am getting an error of lookup value does not support comparing values of type integer with values of type text. Consider using the value or format function to convert one of the values. ABS state actual = a two letter abbreviation, Store number is a series of 5 numbers, and site ID is a series of 5 numbers. Thank you!</P><P><img /></P><P>&nbsp;</P> Thu, 31 Aug 2023 18:34:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-use-lookupvalue-function-to-match-Sites-with-the-state/m-p/3409563#M128855 adrianvandiver 2023-08-31T18:34:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-use-lookupvalue-function-to-match-Sites-with-the-state/m-p/3409672#M128860 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="611140" data-lia-user-login="adrianvandiver" class="lia-mention lia-mention-user">adrianvandiver</a>&nbsp;Either make sure that both your Store Number and Site ID are text or numbers. One of them is currently text and the other is a number. Or, you can always try adding &amp; "" to the number column or + 0 to the text column in your formula.</P> Thu, 31 Aug 2023 19:53:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-use-lookupvalue-function-to-match-Sites-with-the-state/m-p/3409672#M128860 Greg_Deckler 2023-08-31T19:53:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-use-lookupvalue-function-to-match-Sites-with-the-state/m-p/3409772#M128873 <P>thank you, even though one of the columns was integers, it was marked as text in the format. This is whats been messing me up, thank you again!</P> Thu, 31 Aug 2023 20:59:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-use-lookupvalue-function-to-match-Sites-with-the-state/m-p/3409772#M128873 adrianvandiver 2023-08-31T20:59:16Z