cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmhoskinson Frequent Visitor
Frequent Visitor

Append in DAX

I want to create a table appending the ID and Type columns of two separate data sources. I want to include all records of each ID, not just distinct ones. I'm trying to avoid Power Query since the dataset is extremely large. I've read through forums and am not seeing anything that fits my exact situation. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Append in DAX

@jmhoskinson 

That should be a JOIN operation rather than an append, either on SQL or DAX. Check this out:

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

 

Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here.

4 REPLIES 4
Super User
Super User

Re: Append in DAX

Hi @jmhoskinson 

Try UNION(Table1, Table2). See this for details

jmhoskinson Frequent Visitor
Frequent Visitor

Re: Append in DAX

Sorry, forgot to mention that the tables don't have the same number of columns and the tables don't have a relationship.

jmhoskinson Frequent Visitor
Frequent Visitor

Re: Append in DAX

Hope this helps @AlB Basically, I'm looking to append like you can do in Power Query.

Example.png

Super User
Super User

Re: Append in DAX

@jmhoskinson 

That should be a JOIN operation rather than an append, either on SQL or DAX. Check this out:

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

 

Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 160 members 2,061 guests
Please welcome our newest community members: