dax factor based on date range lookup table.
1 Topic
Apply a factor to measure based on date range table
I have a date range table by account number with a factor (i.e. the fuel surcharge). AccountNumber dateFrom dateTo Fuel Surcharge(%) AA 1/1/2023 1/31/2023 5 BB 1/1/2023 1/31/2023 6 AA 2/1/2023 2/28/2023 7 BB 2/1/2023 2/28/2023 8 I have a DAX measure called "Cost". I want a new "Cost+Fuel" measure that factors in the fuel surcharge based on the account and date the transaction occured, but I don't know how to make this happen. Currently I have a relationship on the lookup table's AccountNumber to the transactional data but no relationship on the dateFrom or dateTo columns. Here is what I need the "Cost Plus Fuel" measure to equal. AccountNumber Date Cost Cost Plus Fuel AA 1/20/2023 100 105 BB 2/20/2023 100 106 AA 1/20/2023 100 107 BB 2/20/2023 100 108Solved515Views0likes2Comments