Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

More complicated Repeat Customer Pattern

I'll give an example of what I'm trying to acheive, with some background:   The data I pull is from 1/1/19 to current day.    I'd like to see our repeat/return customers each month. I plan to dis...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    If you have a data model that looks similar to this:

    Then you can get the following output:

    Using this type of calculation:

    Repeat Customer Count = 
CALCULATE (
    COUNTROWS ( 'Customer' ),
    FILTER (
        'Customer',
        CALCULATE (
            COUNTROWS ( VALUES ( 'Data'[Date] ) ),
            FILTER ( ALL ( 'Date'), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
        ) > 1
        && CALCULATE(COUNTROWS('Data')) >= 1
    )
)

    I have uploaded a sample workbook here: Sample Workbook

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If you have a data model that looks similar to this:

Then you can get the following output:

Using this type of calculation:

Repeat Customer Count = 
CALCULATE (
    COUNTROWS ( 'Customer' ),
    FILTER (
        'Customer',
        CALCULATE (
            COUNTROWS ( VALUES ( 'Data'[Date] ) ),
            FILTER ( ALL ( 'Date'), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
        ) > 1
        && CALCULATE(COUNTROWS('Data')) >= 1
    )
)

I have uploaded a sample workbook here: Sample Workbook

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for your solution--it worked!