DATEDIFF Cross table with many to one table relationship

[kdaya]

Hi Community,

Please can you assist i am trying to subtract two dates from two different tables which have a many to one relationship

I have tried using RELATE but i think cause of the one to many relation that does not work

basically trying to subtract the min date for each account by all the dates for that account to get the days

request table will have mutiple dates for the customer and min_date table will have the min date for each customerdays

thanks in advance

[Anonymous]

-- If you have a 1:many rel between
-- min_date and requests, then this
-- will work

[Days Since First Date] = -- calculated column in requests
var __thisDate = requests[Created Time]
var __firstDate = RELATED( min_date[First Date] )
return
	__thisDate - __firstDate

Please note that such calculations should be performed in Power Query, not in DAX.

Best

Darek