Power Pivot Repeat Customers after 1st 30 Days, 2nd 30 Days

[powerbiwizkid]

I am trying to calculate repeat customers after 1st 30 days and 2nd 30 days as separate groups.  I have enclosed a link to a table showing new customers and returning customers.  Pleae help anyone with any ideas.  Many thanks for your help.

https://drive.google.com/open?id=1lK6N56cNyQMOeCMufWi_GGCYg6FNvh5U

[Eric_Zhang]

---

@powerbiwizkid wrote:

I am trying to calculate repeat customers after 1st 30 days and 2nd 30 days as separate groups.  I have enclosed a link to a table showing new customers and returning customers.  Pleae help anyone with any ideas.  Many thanks for your help.

https://drive.google.com/open?id=1lK6N56cNyQMOeCMufWi_GGCYg6FNvh5U

---

@powerbiwizkid

Your requirement is not clear for me. What is the expected output and how to get it the the data in your table?

[powerbiwizkid]

This is my current returning customers DAX formula based on DAX patterns.

[Returning Customers] :=

COUNTROWS (

    CALCULATETABLE (

        VALUES ( Sales[CustomerKey] ),

        VALUES ( Sales[CustomerKey] ),

        FILTER (

            ALL ( 'Date' ),

            'Date'[FullDate] < MIN ( 'Date'[FullDate] )

        )

    )

)

I need to modify that DAX formula to show repeat customers from first purchase after 1st 30 Days, 2nd 30 Days as separate groups.  I'm thinking the best approach is to use INTERSECT for the second argument (underlined portion of DAX formula) of returning customers but not quite sure how to do it.  Please help anyone with any ideas.  Many thanks.