Forum Discussion

awff's avatar
awff
Helper III
4 years ago
Solved

Finding the earliest date across multiple rows

Hi fellow PBI'ers, I'm trying to create a measure that lists the earliest date a product was held by customers.    Below is a simplified mock up data with the earliest dates bolded:   Clien...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi awff ,

     

    Try this measure to see if this will meet your needs:

    Measure = CALCULATE(MIN('Table'[Start Date]),ALLEXCEPT('Table','Table'[Client],'Table'[Product]))

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SteveHailey's avatar
SteveHailey
Solution Specialist
4 years ago

Hey awff. This should do the trick:

New Table = 
ADDCOLUMNS(
    SUMMARIZE( 'Table', 'Table'[Client], 'Table'[Product] ),
    "Earliest Date", CALCULATE( MIN( 'Table'[Start Date] ) )
)
awff's avatar
awff
Helper III
4 years ago

Thanks SteveHailey ,

I'm assuming this is for a new table

is there a way i can have this as a measure for a table visualisation?