Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Original question posted by @actzikas within a wrong thread. This post aims to answer actzikas question:
"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" link to original post
Solved! Go to Solution.
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?
As you haven't stated what columns [Table 2] contains or what your output table might look like - I’ll signpost you to a great video by @reza_rad (links below) where he explains the difference between the two types of combining query options available in Power BI; A: "Merge", and B:"Append".
If I may also suggest using the functions already accessible on the Home menu. It is much easier than writing your own "M" script (however, it can be done via the "Table.NestedJoin" function for merge or for append “Table.Combine”.)
Links to more info
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?
As you haven't stated what columns [Table 2] contains or what your output table might look like - I’ll signpost you to a great video by @reza_rad (links below) where he explains the difference between the two types of combining query options available in Power BI; A: "Merge", and B:"Append".
If I may also suggest using the functions already accessible on the Home menu. It is much easier than writing your own "M" script (however, it can be done via the "Table.NestedJoin" function for merge or for append “Table.Combine”.)
Links to more info
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |