Having trouble with LOOKUPVALUE

[Anonymous]

Column 2 = LOOKUPVALUE('REC-SHIP'[Shipments.DATED], 'REC-SHIP'[CYCLE_ID], 'REC-SHIP'[Previous Cycle])

This is creating an error, a table of multiple values was supplied.

I do not understand, as I am supplying the value from the very same table.

Is it rying to tell me that lookupvalue is returning more than one value? Is lookupvalue() the supplier here?

[Anonymous]

If you want to know how to write more optimized versions of the lookup using other techniques, please go to

https://dax.guide/lookupvalue/

Best

D

[Greg_Deckler]

Yes, it is returning more than one value. You can use the Alternate result parameter to return something like BLANK to get around the error. 

If you want to see the values being returned, do this:

CONCATENATEX(

  DISTINCT(

    SELECTCOLUMNS(    

       FILTER('REC-SHIP','REC-SHIP'[CYCLE_ID] = 'REC-SHIP'[Previous Cycle]),

       "Shipments.DATED",

       'REC-SHIP'[Shipments.DATED]

    )

  )

)