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 A...
  • VahidDM's avatar
    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!!