Copy first date into other rows with the same order

[Anonymous]

Hello all!

We wanna give all the orders with the same order number the first date of those order numbers.

Does anybody have an idea how to set it up?

Thanks!

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may try to use ALLEXCEPT function as below:

Measure =
CALCULATE ( MIN ( Table1[date] ), ALLEXCEPT ( Table1, Table1[Order number] ) )

Regards,