Create a dax measure to lookup value

[rkalantan]

Hi

I have this table with aircraft groups 320, 330, 777, and 787 and planned utilization

Table 1

Aircraft	Planned utilization
320	12.5
330	12.8
777	13.1
787	12.9

in another table I have same aircarft group, and I want to lookup the planned utilization values based on the aircarft groups

table 2

Aircarft	Crew	Flying	planned utilization
320			?
330			?
777			?
787			?

Question: How to bring planned utilization from table 1 to table 2 by creating a dax measure in power view (not power query)?

thanks

[DataInsights]

@rkalantan,

Try this calculated column:

Flying planned utilization =
LOOKUPVALUE (
    Table1[Planned utilization],
    Table1[Aircraft], Table2[AircraftCrew]
)

[rkalantan]

Hi and thanks for trying

no it didnt work, apperantlu third item in lookupvalue has to be an expression

[DataInsights]

@rkalantan,

What error are you getting? Would you be able to provide a pbix?