I'm trying to joining multiple tables and i dont know how to do it.
I tried to append, merge this queries using FULLOUTERJOIN, however i wasnt successfull.
Someone please can help me?
Solved! Go to Solution.
Create a new table and add the following formula:
Table = UNION(SELECTCOLUMNS(Table1,"ID", Table1[id],"Name", Table1[name],"Value1", Table1[value],"Value2", "" ), SELECTCOLUMNS(Table2,"ID", Table2[id],"Name", Table2[name],"Value1", "","Value2", Table2[value] ), )
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.