Forum Discussion
jmhoskinson
Helper I
Helper IAppend 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 da...
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.
jmhoskinsonHelper I
Helper IHope 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!