Forum Discussion

spud's avatar
spud
Regular Visitor
8 years ago

first product ordered

 I would like your help:   short hypothetical example   a vendor sells the following items: cherries code 283 apples   code 282 oranges code 111   A customer orders cherries and apples all o...
First product order
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

spud I assumed there is order date in the data, add following column to identify when product was ordered first time.

 

Is this first order = 
VAR __itemsOrders = CALCULATETABLE( VALUES( Table3[Product] ), FILTER( ALL( Table3 ), Table3[OrderDate] < EARLIER( Table3[OrderDate] ) ) )
RETURN
IF( NOT Table3[Product]  IN __itemsOrders, "Yes" )