Skip to Content

I want to find a value in a list, but choose one based on a date falling within a range.

The invoice date needs to be between a "from" date and a "to" date, then find the rate of the product. The list will have the product listed multiple times, but with different rates for different periods. I created variables for the date fields to measures. Tried comparing them but did not find a value.

What would the formula be in a variable to accomplish this? I tried the following, but received a blank:

=[List Price] ForEach ([Material]) Where ( [BD_Date] Between ( [LP_from];[LP_to] ) )

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers