Forum Discussion
syntax is incorrect
Im trying to convert this excell formula into BI to get the data for the column to match up with the others but im not sure what the correct formula in BI would be
New for 2018 Part Number = IF(ISBLANK(LOOKUPVALUE('New 2018 Instrument Part Numbers'[Jason comment],'New 2018 Instrument Part Numbers'[Product Code],'Oracle Transactions Instrument Master'[Material]),"2017 Part Number","New 2018 Part Numbers" && LOOKUPVALUE('New 2018 Instrument Part Numbers'[Jason comment],'New 2018 Instrument Part Numbers'[Product Code],'Oracle Transactions Instrument Master'[Material])
))
Hi dkehoe32,
In your formula, the data type of search_columnName and search_value are the same? They must be same and compared.
Thanks,
Angelia