Forum Discussion
Power Query / Power pivot countifs from multiple tables
I have 2 tables with a bunch of data, corresponding in two columns with Attribute1 and date. I'd like to create a table that: - has two columns with the unique combinations of Date and Atrribute...
There is a bug with combining tables in the Power Query editor right now. As a mitigation you can use (assuming all tables have the same schema):
#table(Value.Type(table1), Table.ToRows(table1) & Table.ToRows(table2) & Table.ToRows(table3))
Can you point me to the bug report / explanation? Because I've used it a couple of times and once had some very unexpected results.