Forum Discussion
Append in DAX
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.
Hope this helps AlB Basically, I'm looking to append like you can do in Power Query.
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.
Hi jmhoskinson ,
I'm having a similar requirement now.
Could you share how you acheived this?Thanks in advance!