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...
If your looking for just the count of the combinations then, all you need to do, is apply a Group by on the main table, selecting both the Date and Attribute columns.
No I am looking for a table that has counts for unique dat/attribute combo's from two other tables. Pls let me know what is not clear about the screenshot I posted in the opening post, with the intended end result. Thank you! 🙂