Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
very super basic question
I do have Table 1 with
I do have table to Table 2 with
I would like to create a new column (in the advanced editor) in table 2 getting the name Info from column 1
Can you please telle me the formula I need to use ?
thanks a million
fred
Solved! Go to Solution.
Hello @Thrasymaque
you can use Table.NestedJoin to join both tables. Afterwards you can expand the columns you needed from the newly created column. here an example (not tested)
JoinTables = Table.NestedJoin(Table1, {"project ID"}, Table2, {"project ID"}, "Table2", JoinKind.LeftOuter)
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello @Thrasymaque
you can use Table.NestedJoin to join both tables. Afterwards you can expand the columns you needed from the newly created column. here an example (not tested)
JoinTables = Table.NestedJoin(Table1, {"project ID"}, Table2, {"project ID"}, "Table2", JoinKind.LeftOuter)
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
thank you
thought also was the best way as it seems I can not import value in it
many thx
br
F.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.