Dax LOOKUPVALUE for duplicates values and different length values
Hi I need help to enhance my DAX commans below. Below the Dax lookup command works initally what i need but there was changes to the values. O 1) of the changes was with duplicate values. When i run the dax lookupvalue command it gives an error of - A table of multiple values was supplied where a single value was expected 2) The second change was that the current Dax command was loking at the length which was all 7 in length. Now the part number could be 4 to 14 charters long. All suggestion for both or 1 of the items is helpful
