Counting a distinct clients by comparing current & prior

[Anonymous]

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

[Anonymous]

Try using intersection of sets:

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