distinct count with filter

Question

Good Morning,I need some help please with a distinct count with a filter.The count is for customer, i need to filter on two dates so it is only counting where the first date is greater than the second date.For example in the below table i would get a result of 3:CustomerDate 1Date 2126/01/202028/02/2022128/12/202125/11/2021231/02/202231/01/2022301/06/202131/05/2021305/08/202007/04/2022

lukiz84 · Answer

Hi,&nbsp;CustomerCount =
   CALCULATE(
      DISTINCTCOUNT(table[Customer]),
      FILTER(
         table,
         table[Date 1] &gt; table[Date 2]
      )
   )

anonymous · Answer

Thank you, i forgot to say that the two dates are from two different tables.&nbsp;

lukiz84 · Answer

And how are those tables connected?!

anonymous · Answer

Hi the tables are joined by the customer number

lukiz84 · Answer

How? Can you show a picture?&nbsp;How does Table 1 know, which Date 2 belongs to which Date 1?

Forum Discussion

distinct count with filter

5 Replies

Related content

count distinct

Distinct Count with filter

Distinct Count

Distinct Count, Filter

Distinct count

Customer	Date 1	Date 2
1	26/01/2020	28/02/2022
1	28/12/2021	25/11/2021
2	31/02/2022	31/01/2022
3	01/06/2021	31/05/2021
3	05/08/2020	07/04/2022