Forum Discussion

inlam's avatar
inlam
Regular Visitor
2 years ago

Power Query issue trying to create a new table

Hi Sirs,    I'm struggling trying to create a new table/query in Power Query that gives me the correct output for this scenario:   From a Table 1. Year Month 2023 1 2023 2   And...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

inlam , You can use the Merge option in Power Query

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo

 





 

 

Code of merged table

 

let
Source = Table.NestedJoin(#"Table 1", {"Year"}, #"Table 2", {"Year"}, "Table 2", JoinKind.Inner),
#"Expanded Table 2" = Table.ExpandTableColumn(Source, "Table 2", {"Year", "Amount"}, {"Table 2.Year", "Table 2.Amount"})
in
#"Expanded Table 2"