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.