Compare data records with previous period and calculate Count

[mak]

Goal is to find how many Clients were a repeat Clients

I have a dateSlicer and a table with Clients with VisitDate

Clients Table

Client Id .   VisitDate . 

Report is a Matrix as below

DateSlicer[Date] .  #Clients .   #RepeatClients .  %RepeatClients

Jan .                     10 .          0                         0

Feb                       20           5                         50%

Now sure how should I proceed on it

thank you

[Phil_Seamark]

Hi @mak

You can probably get something basic up and running with the following measures:.  Please just change the table/column names to match yours.

Oh and I coverted your first column to an actual date , eg '2017-01-01' rather thant the text 'Jan'

Sum of Clients = CALCULATE(sum('Table2'[#Clients]))


Sum of Clients Previous Month = CALCULATE('Table2'[Sum of Clients],PREVIOUSMONTH('Table2'[Date]))


Difference = [Sum of Clients]-[Sum of Clients Previous Month]