Input Error

[Sirfyaad]

can you explain me why this function not given input ANY( SELECT(Selling Price List[PRICE], AND(
[Item SKU Code] = [_ThisRow].[SKU],
[Selling Channel] = [_ThisRow].[CHANNEL]
)))

[Aurelien]

Hi @Sirfyaad 

If my understanding is correct, this:

ANY( 
  SELECT(Selling Price List[PRICE], 
    AND(
     [Item SKU Code] = [_ThisRow].[SKU],
     [Selling Channel] = [_ThisRow].[CHANNEL]
    )
  )
)

will give a price for a record that matches the two conditions SKU and Channel.

Are you sure you have a record that does so ?

Can you try in additional virtual columns, these expressions:

Virtual Column 1:
 
  FILTER("Selling Price List", 
    AND(
     [Item SKU Code] = [_ThisRow].[SKU],
     [Selling Channel] = [_ThisRow].[CHANNEL]
    )
  )

Virtual Column 2:

ISNOTBLANK(
  FILTER("Selling Price List", 
    AND(
     [Item SKU Code] = [_ThisRow].[SKU],
     [Selling Channel] = [_ThisRow].[CHANNEL]
    )
  )
)

Virtual Column 3:

  SELECT(Selling Price List[PRICE], 
    AND(
     [Item SKU Code] = [_ThisRow].[SKU],
     [Selling Channel] = [_ThisRow].[CHANNEL]
    )
  )

 Once done, can you share screenshots of your table structures, and the result of these expression for a record you make ? 

[Sirfyaad]

I want that when the [SKU] column and [channel] match with my ref data, then the [Price] in the [Selling Price] column should be auto filled. 

[Aurelien]

Thanks for screenshot of your table.

On table CAMPUS SCAN SHEET: I suggest you set all of your "formula" expressions in the "initial value" field instead.

About this:

"Once done, can you share screenshots of your table structures, and the result of these expression for a record you make ? "

Did you try my suggested expressions ?

[Sirfyaad]

Thank you for your suggestion.  below function its working. 

NY( 
  SELECT(Selling Price List[PRICE], 
    AND(
     [Item SKU Code] = [_ThisRow].[SKU],
     [Selling Channel] = [_ThisRow].[CHANNEL]
    )
  )
)

[Aurelien]

This is yours, I didn't change anything 🤣