VALUELOOKUP

Question

I think VALUELOOKUP is what i am wanting to use. I am trying to pull a freight rate column from one table and put those values into another table.&nbsp;Total Freight = LOOKUPVALUE(LoadTrackingData[Driver],LoadTrackingData[TotalFreightRate],'DRIVER BONUS'[Driver]) here is the formula i am using. but i get an error. i am wanting to show the values of total freight from the load tracking table in the driver bonus table.&nbsp;

vojtechsima · Answer

Hi,&nbsp;jbenson&nbsp;If you wanna find Total Freight, you have to write it like this:
 LOOKUPVALUE(LoadTrackingData[TotalFreightRate],LoadTrackingData[Driver],'DRIVER BONUS'[Driver])

jbenson · Answer

i get an error that says a table of multiple values was supplied where a single value was expected

ryan_mayu · Answer

jbenson&nbsp;
pls check the data ,i think there is a one to many relationship.
could you pls provide the sample data?

jbenson · Answer

i removed any relationships i had, but i still got the same error. What i am trying to accomplish is take the payroll % from table the driver bonus and divide by the freight rate from the load tracking table, i need to do this on a per row basis so its by each driver.&nbsp; i do the add column and try and divde the payroll % by the total freight rate but i get the same value for each row. I am not sure if my date columns are messing me up because one has the date by the week on the driver bonus table and the load tracking table is a date by each day? i have uploaded the snap shots of the two tables&nbsp;

ryan_mayu · Answer

jbenson&nbsp;
could you pls provide the sample data and expected output?

Forum Discussion

VALUELOOKUP

7 Replies

Related content

Skipping blanks in valuelookup

Power BI embedded reports with RLS

Re: Link supplier to corresponding products but in terms of sales quantities

Creating a new text colum based on a number range in another column

How to look for data from a single cell in column "a", in the whole of column "b".