Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I want to merge two tables: one is imported from a csv file, the other is created in power bi with dax. I want to combine these two tables, but when I want to merge them (Edit Query) I only see the imported table, not the dax table.
How do I do this??
You can try my technique here:
http://social.technet.microsoft.com/wiki/contents/articles/32915.power-bi-merge-query-with-m.aspx
You would probably need to create another calculated table that merges the two together.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |