Skip to Content
0
May 22, 2018 at 03:26 PM

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

71 Views

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] ) )