Identify the customers who ordered again after our promotion

[Andrew_na_lang]

I need help. We are running a promotion and identifying how many new customers have used the promotion. 
A calculated column (Conversion) was created with a DAX Formula of: 

Conversion =
VAR _FirstOrder = Sheet1[ORDER RANK] = 1
VAR _Promo = Sheet1[First_ORDER_PROMOTION] = "Yes"

RETURN

IF( _FirstOrder && _Promo , "Converted", "")

Now, I need to create another column where I can identify who amongst the customers who were "converted" submitted another order. In this table, customers A, B, and E who were converted already had their 2nd order. I need to create a calculated column and have them tagged as converted to second.

DESIRED OUTPUT: 

[smpa01 · Accepted solution]

@Andrew_na_lang  calculated column

Column =
IF (
    'fact'[orderRank] = 2
        && ISBLANK (
            TOCSV (
                INDEX (
                    2,
                    ALL ( 'fact'[pickupDate], 'fact'[custID] ),
                    ORDERBY ( 'fact'[pickupDate], ASC ),
                    KEEP,
                    PARTITIONBY ( 'fact'[custID] )
                ),
                100,
                ","
            )
        )
            = FALSE (),
    "Converted to Second"
)

[FreemanZ]

hi @Andrew_na_lang 

try like:

Convertrd to 2nd order =

VAR _ordercount = 

COUNTROWS(

    FILTER(

        TableName,

        TableName[CustomerID]=EARLIER(TableName[CustomerID])

            &&TableName[Converted]="Converted"

    )

)

RETURN

IF(_ordercount>1, "Converted to second")

[Andrew_na_lang]

@FreemanZ it didn't work

[FreemanZ]

hi @Andrew_na_lang 

what do you get?

[Andrew_na_lang]

@FreemanZ  blank

 

[FreemanZ]

hi @Andrew_na_lang 

try like:

Convertrd to 2nd order =

VAR _ordercount = 

COUNTROWS(

    FILTER(

        TableName,

        TableName[CustomerID]=EARLIER(TableName[CustomerID])

    )

)

RETURN

IF(_ordercount>1, "Converted to second")

or you would need to enrich your sample data to better reflect your challenge.