Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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!!
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!!
That worked!
Thank you very much!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |