Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for your reply. I tried this as a calculated column in a table containing unique date/attribute combo's. This is what I get:

Also not sure how this would work as there is no mention of attribute, and I'm specifically looking for counting date/attribute combinations.

artemus's avatar
artemus
Microsoft Employee
5 years ago

You would add this as a custom column to your table which has distinct date/attribute.

 

For attribute, simply replace [Date] with [Attribute] when you add another column.

  • artemus's avatar
    artemus
    Microsoft Employee
    5 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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! 🙂