Forum Discussion

dkehoe32's avatar
dkehoe32
Helper I
8 years ago

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      
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi dkehoe32,

Please share a screenshot shown the DAX you used?

Thanks,
Angelia

dkehoe32's avatar
dkehoe32
Helper I
8 years ago

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])
  ))

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    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