Forum Discussion

Rafaelpalma's avatar
Rafaelpalma
Frequent Visitor
4 years ago
Solved

Create column with first purchase by client

Hello guys! I need some help, please. I need to create a column that returns the customer's first purchase. Example: Customer x purchase 1 = 10/15/2021 purchase 2 = 10/16/2021 First purchase column Always need to come 15/10/2021. I need to make the column bring the information of the first purchase, but always considering the customer as a criterion.I tried the dax below, but it didn't work.

calculate(min(Mov_Site[Data]),'Mov_Site'[CodigoCliente])

Can someone help me please?

 

  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Rafaelpalma 

     

    Can you share a sample of your data and result you are looking for?

    BTW, try this:

    calculate(min(Mov_Site[Data]),ALLEXCEPT('Mov_Site','Mov_Site'[CodigoCliente]))

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

2 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi Rafaelpalma 

     

    Can you share a sample of your data and result you are looking for?

    BTW, try this:

    calculate(min(Mov_Site[Data]),ALLEXCEPT('Mov_Site','Mov_Site'[CodigoCliente]))

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!