Forum Discussion

EladAppelNN's avatar
EladAppelNN
Frequent Visitor
3 years ago

Create new query based on parameters

Hi, Lets say I have a table/query for products, and a table/query for countries   query1         |                  query2 Product        |                 Countries -Tomato       |              ...
Need Help
sendilc's avatar
sendilc
Frequent Visitor
3 years ago

Hi, 

 

Pls create 2 tables Products and Countries and then use the below PQ

 

let
Source = Product,
#"Added Custom" = Table.AddColumn(Source, "Custom", each Countries),
#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Countries"}, {"Countries"})
in
#"Expanded Custom"

 

Regards

 

  • EladAppelNN's avatar
    EladAppelNN
    Frequent Visitor
    3 years ago

    Thanks for the detailed explanation, where should this be enterred? asa  new custom column?