Hi.
I have a table with two columns - "Name" and "Year".
There are several rows with same name and year, and there are several rows with same name and different year.
I would like to Count names, where there are at least one row with the name and year = 2014 and one row with the name and year = 2015. This should be counted as one name.
Is that possible using e.g. Calculate(DISTINCTCOUNT(NAME);Filter(???))
Looking so much forward to your answer.
Thanks.
I have a table with two columns - "Name" and "Year".
There are several rows with same name and year, and there are several rows with same name and different year.
I would like to Count names, where there are at least one row with the name and year = 2014 and one row with the name and year = 2015. This should be counted as one name.
Is that possible using e.g. Calculate(DISTINCTCOUNT(NAME);Filter(???))
Looking so much forward to your answer.
Thanks.