Forum Discussion
kevlarmpowered
Helper I
Helper IOne to Many ... not so easy when using columns in a table from both tables
Assignments (1) ID Assigned To The values being Tom Richard Harry Bob Schedules (Many) ID Scheduled To Jane Beth April I've done this before (at least I think I have) an...
Ashish_Mathur
Super User
Super UserHi,
U used this M code
let
Source = Table.NestedJoin(Table1,{"ID Name"},Table2,{"ID Name"},"Table2",JoinKind.LeftOuter),
#"Expanded Table2" = Table.ExpandTableColumn(Source, "Table2", {"Scheduled To"}, {"Scheduled To"})
in
#"Expanded Table2"
Here's the result i got
kevlarmpoweredHelper I
Helper I
I was trying to do it in DAX... not through M.