Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
6 years ago
Solved

First Invoice date for each customer

I wanted to create a measure to get the First invoice date for each customer.   The measure should return the results from the start date and ignore the filter/visuals.   Below is the table. ...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi gauravnarchal ,

     

    You can use something like:

     

    CALCULATE(MIN(TABLE[DATE]), ALLEXCEPT(TABLE, [CUSTOMER NO]))