Create column with first purchase by client

[Rafaelpalma]

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 · Accepted solution]

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!!

[Rafaelpalma]

That worked!

Thank you very much!!