Date of second client order

[leonardopp]

Hi all,

Im trying to calculate the repurchase% of my clients. For that i created one new column at my client table that shows me the date of the first order of my client.

First Buy = FIRSTDATE('Vendas com Produtos'[DATA_EMISSAO_NF])

After that I need to create anothe column at my client table that shows me the date of the second order. 

Second Buy = ??????

I tried to filter this firstdate formula, but it did not work.

My sales table have the clientID and the sales date.

I need help on this.

[Zubair_Muhammad · Accepted solution]

@leonardopp

Try this

Second Buy =
VAR FirstBuy = [First Buy]
RETURN
    CALCULATE (
        MIN ( 'Vendas com Produtos'[DATA_EMISSAO_NF] ),
        'Vendas com Produtos'[DATA_EMISSAO_NF] > FirstBuy
    )

[leonardopp]

I got this error when tried this formulad.

"The expression contains many columns, but it can only be uses one columns in one expression True/False..."

[leonardopp]

Sorry, My mistake. It worked just fine. Thanks

[Zubair_Muhammad]

@leonardopp

Because you didn't use the variable as the last expression inside Filter

Just replace

Clientes[Preimeria Compra]

with

Firstbuy

Also the variable is supposed to hold the FIRSTBUY measure