Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculating first order date for by account

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 a...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    Try this

     

    =
CALCULATE (
    MIN ( TableName[OrderDate] ),
    ALLEXCEPT ( TableName, TableName[Account number] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi Anonymous

 

Try this

 

=
CALCULATE (
    MIN ( TableName[OrderDate] ),
    ALLEXCEPT ( TableName, TableName[Account number] )
)
marianamarques's avatar
marianamarques
Icon for Advocate I rankAdvocate I
8 years ago

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's avatar
    marianamarques
    Icon for Advocate I rankAdvocate I
    8 years ago

    Never mind, that calculated column that I mentioned is working fine :)

    thanks!