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

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    Try this

     

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

3 Replies

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