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...
You can use something like:
List.Count(List.Select(Table_1[Date], each _ = [Date]))
That is:
List.Count - Count items in a list
- List.Select - Only include item in the list that match a criteria
- - Table_1[Data] - Get the column "Data" for Table_1 as a list
- - each _ = [Date] - The criteria, for each item in the list, check if it "_" is equal to the current row's Date field.
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.