Forum Discussion

basrooz's avatar
basrooz
Icon for Advocate I rankAdvocate I
5 years ago

Pull one value from other table based on date range

Hi, I have two tables. One table contains a user ID, a date, and a cost per order. The date is this table is showing as of when the cost per order should be applied. For instance for user A, the va...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

basrooz 

you can create a column

Column = 
VAR _date=maxx(FILTER('User','Order'[User ID]='User'[User ID]&&'User'[Date]<='Order'[Order date]),'User'[Date])
return maxx(FILTER(User,'Order'[User ID]='User'[User ID]&&'User'[Date]=_date),'User'[Cost per order])