Solved! Go to Solution.
So, you can do this via a Merge query or you could use SQL (Advanced) or you could do it in a single query in Power Query:
https://social.technet.microsoft.com/wiki/contents/articles/32915.power-bi-merge-query-with-m.aspx
So, you can do this via a Merge query or you could use SQL (Advanced) or you could do it in a single query in Power Query:
https://social.technet.microsoft.com/wiki/contents/articles/32915.power-bi-merge-query-with-m.aspx
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.