Counting a distinct clients by comparing current & prior

Anonymous — Sun, 29 Mar 2015 19:32:54 GMT

Hi All,

I am trying to client all of the clients in the current time period who ALSO had activity in a prior period.

The set analysis to determine the correct client count for the current time period is:

Count(Distinct {<TransactionDate = {$(var_currentdates)}>}[Client Name])

I now need to extend this formula to only include clients that ALSO had activity in the prior period

TransactionDate = {$(var_priordates)

Any help would be greatly appreciated

Re: Counting a distinct clients by comparing current & prior

Anonymous — Sun, 29 Mar 2015 19:45:43 GMT

Try using intersection of sets:

Count({<TransactionDate = {$(var_currentdates)}> * <TransactionDate = {$(var_priordates)}>} distinct [Client Name])