hi @Lobo1908
the solution consists 3 steps:
1) split the codes column to rows with Power Query,
2) connect the splitted table with the lookup table
3) get the expected RankTable
here comes the details:
1) split to rows
2) connect with the lookup table
3) create a new table with this:
RankTable =
ADDCOLUMNS(
VALUES(TableName[PartNo]),
"Rank",
CALCULATE(
MAXX(
TableName,
RELATED(Lookup[Rank])
)
)
)
the result looks like this:
hi @Lobo1908
the solution consists 3 steps:
1) split the codes column to rows with Power Query,
2) connect the splitted table with the lookup table
3) get the expected RankTable
here comes the details:
1) split to rows
2) connect with the lookup table
3) create a new table with this:
RankTable =
ADDCOLUMNS(
VALUES(TableName[PartNo]),
"Rank",
CALCULATE(
MAXX(
TableName,
RELATED(Lookup[Rank])
)
)
)
the result looks like this:
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
