Forum Discussion

Josh_BI_UK's avatar
Josh_BI_UK
Helper II
8 years ago
Solved

Reference two or more Columns as Source in new query

Hi PWRBI family,   How do you references two columns from a table in another query as the source for a new query using Power BI - Query editor?     Example   Query A > Table called: "Tbl_Cours...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    I speak from personal experience - if there is difference in performance I don't think it will be visible in most cases
    I do prefer the clarity of the code in my syntax, it's quite straightforward so in case you need to handover it shouldn't be too complex

    as for learning you can give this a go
    https://msdn.microsoft.com/en-us/query-bi/m/power-query-m-language-specification

    a bit tough read, but gives much better understanding of M

    EDIT
    you can even simplify it more

    let
    Source = Table.SelectColumns(Tbl_CoursesbyTutorTable,{"Course Codes", "Course Title"})
in
    Source

    but I actually prefer to have the steps separated

actzikas's avatar
actzikas
Frequent Visitor
6 years ago

Could you bring into two tables as a source? 

= Table.SelectColumns(Table 1, {"OwnerId", "Type", "CreatedDate", "Creator_Role__c"}) and somehow have another Table.SelectColumns for Table 2?

Josh_BI_UK's avatar
Josh_BI_UK
Helper II
6 years ago

Hi  actzikas, I hope I'm interpreting your question, right? From the looks of it you wish to Join or Combine two tables into one query?
 
I don't think this post best suits your question. May I suggest looking at this post Append vs Merge using Power Query ; or if that doesn't help please add further clarification.
 
Teamwork makes the BI work - always happy to help🙌