Forum Discussion
rachaelwalker
Resolver III
Resolver IIILookup value based on multiple conditions from another table
I have two tables that are related many-to-many. They are related by Job Number. Field Rework and Time Entries. From the Field Rework table, I would like to lookup the sum of hours in the Time Entrie...
Regarding the ConcatenateX usage, you can flexibly get the result you want by writing a formula like below:
The above formula results in the output like below:
StrategicSavvy
Resolver II
Resolver II
How about using multiple search conditions using LOOKUP formula :
LOOKUPVALUE (
<result_columnName>,
<search_columnName>,
<search_value>
[, <search2_columnName>, <search2_value>]…
[, <alternateResult>]
)
rachaelwalkerResolver III
Resolver IIII cannot get lookupvalue to work. It says it cannot see my column in the Time Entries table. I used a similar measure but it is returning the sum of all hours and not the sum for just that date. I understand what it is doing and why I am getting the results but I dont know what to change to make it work the way I need it to
Hours Worked Look UP =
CALCULATE(
SUM('Time Entries'[Hours Worked]),
FILTER(
ALLNOBLANKROW('Field Rework and Delay Tracker'[Date]),
'Field Rework and Delay Tracker'[Date] = MAX('Time Entries'[Date Entered])
)
)