Calculating first order date for by account

[Anonymous]

hi i have many rows of sales data which lists the account number, the order number (can be multiple order numbers for the same custome rand duplicated order numbers for the same customer). there is also the order date.

I need a way to find the first order date for each customer account. is there a simpe way to do this?

thanks

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Try this

=
CALCULATE (
    MIN ( TableName[OrderDate] ),
    ALLEXCEPT ( TableName, TableName[Account number] )
)

[marianamarques]

Hi, I'm trying to do something similar but I would exclude orders that have a "0" value (sample orders) and then get the second order date.
I tried the following:

First Order Date = CALCULATE(FIRSTDATE('Orders'[Document Date]),ALLEXCEPT('Orders','Orders'[Customer Code]),'Orders'[Revenue]<>0)

But that is just not showing the first date for customers that have orders = 0, but what I would like to have is the first date of a <>0 order (which in that case would be the second order date).

Any ideas how I can get that date?

Thank you

[marianamarques]

Never mind, that calculated column that I mentioned is working fine 🙂

thanks!