Forum Discussion
APEREZ2
Advocate I
Advocate IHow to define if date is in a range
Hi, I have the following problem. I need to relate the table of prices: StartingPrice EndPrice Product Unit Price 2021-03-01 2021-05-22 Apple Tree 1.24 2021-05-23 2021-07-31 Apple ...
Use below formula in a custom column in second table. First table is PriceTbl.
Table.SelectRows(PriceTbl, (x)=> x[StartingPrice]<=[Sales Date] and x[EndPrice]>=[Sales Date] and x[Product]=[Product]){0}[Unit Price]
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalUse below formula in a custom column in second table. First table is PriceTbl.
Table.SelectRows(PriceTbl, (x)=> x[StartingPrice]<=[Sales Date] and x[EndPrice]>=[Sales Date] and x[Product]=[Product]){0}[Unit Price]