Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @Antmkjr
You could add below codes to TableA. Modify the step and column names accordingly. Download the attached pbix for details. Let me know if you have any questions.
#"Merged Queries" = Table.NestedJoin(#"Changed Type", {"No"}, TableB, {"No"}, "TableB", JoinKind.LeftOuter),
#"Aggregated TableB" = Table.AggregateTableColumn(#"Merged Queries", "TableB", {{"Value", List.First, "Lookup Value"}})
TableA: 'AP Payment 1 Matched'
TableB: 'Discoverer-Payables'
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi @Antmkjr
You could add below codes to TableA. Modify the step and column names accordingly. Download the attached pbix for details. Let me know if you have any questions.
#"Merged Queries" = Table.NestedJoin(#"Changed Type", {"No"}, TableB, {"No"}, "TableB", JoinKind.LeftOuter),
#"Aggregated TableB" = Table.AggregateTableColumn(#"Merged Queries", "TableB", {{"Value", List.First, "Lookup Value"}})
TableA: 'AP Payment 1 Matched'
TableB: 'Discoverer-Payables'
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.