1 to many relationship - want to find time creation difference between 2 linked table

[ZeNable]

Hi All,

I have a scenario where I have 2 tables with a 1 to many relationship

Product

ProductId - ProductName, CreationDate

Order

OrderID - ProductID - CreationDate

I would like to get de time difference between product.CreationDate and the CreationDate of the first linked oder ( for every Product )

Could someone help me please ?

[ZeNable]

Thanks !

[johnt75 · Accepted solution]

You could create a calculated column with the below DAX

First order date =
MINX ( RELATEDTABLE ( 'Order' ), 'Order'[Creation date] )