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.
Hello,
I'm trying to join two tables via custom function. The tables have to merge with a LeftOuter join multiple times (so a loop in the custom function is requiered).
Table one is the leading table,
For every column (except the first column "Anzahl.oo_id - Kopie") in table one a join have to be made.
In table two there will be used the column ("id") for every join.
This is how far I can get with my limited knowledge.
() => let #"Zusammenführte Abfragen" = Table.NestedJoin({"Price_Amount__unit"},#"pimcore units",{"id"},"pimcore units",JoinKind.LeftOuter), #"Erweiterte pimcore units" = Table.ExpandTableColumn(#"Zusammenführte Abfragen", "pimcore units", {"abbreviation"}, {"pimcore units.abbreviation"}) in #"Erweiterte pimcore units"
I hope someone can help me and thanks in advance.
Solved! Go to Solution.
@Anonymous,
Take a good look at parameters of Table.NestedJoin.
@Anonymous,
Take a good look at parameters of Table.NestedJoin.
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.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |