PowerPivot DAX Earliest Date

[gavs73]

Hi, would appreciate any help with this...

I have a table of UserNames and another table of Dates when orders were made and what was bought and by which users. ( there are multiple dates and orders by the same users ).

Into the UserName table I'd like to return the earliest date each particular User bought a specific item, can this be done in DAX ?

LOOKUP Earliest 'Date' from ORDER_TABLE where UserName = UserName and Product = Product X

Thanks
Gav

 

[Matt Allington]

Why do you want to do this? Generally it is not required to do this as a column (there are exceptions). Calculated Columns vs Measures in Dax • Explained by Excelerator BI

you can write a measure
Earliest order =min(orders[date])

then create a pivot table, put the UserName on rows and the measure in values