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.
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.
Solved! Go to Solution.
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.
You could use a combination of UNION and SELECTCOLUMNS creating a calculated table which I did to solve a similar situation.
Hope this helps @AlB Basically, I'm looking to append like you can do in Power Query.
Hi @jmhoskinson ,
I'm having a similar requirement now.
Could you share how you acheived this?
Thanks in advance!
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.
Sorry, forgot to mention that the tables don't have the same number of columns and the tables don't have a relationship.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |