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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

LOOKUPVALUE is defined here:

 

https://msdn.microsoft.com/en-us/query-bi/dax/lookupvalue-function-dax

 

Basically, you generally want 3 parameters:

  1. Result column - what you are trying to return
  2. Search column - the column to search for a value
  3. Search value - the value to search for in the Search column.

 

The syntax you have is odd. The third parameter is nonsensical. You have a mash-up of a column reference and then a text string. Perhaps if you can describe what you are trying to achieve?

dkehoe32's avatar
dkehoe32
Helper I
8 years ago

Im trying to take this column from excell and move it into my BI table.  I can get it into BI without the "2017 Part Number" but it just gives me blank cells instead of the text.  The excell formula takes data from other excell sheets and thats essentially what im trying to do in BI

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

    Hi dkehoe32,

    You can create a measure using the formula to get the expected result.

    =
IF (
    ISBLANK ( LOOKUPVALUE ( [D_colum], [column], "I2" ) ),
    "2017 Part Number",
    "New 2018 Part numbers" && LOOKUPVALUE ( [D_colum], [column], "I2" )
)


    Thanks,
    Angelia

    • dkehoe32's avatar
      dkehoe32
      Helper I
      8 years ago

      I just tried that formula and it says "Expressions that yield variant data type cannot be used to define calculated columns"

      • 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