topic DATEDIFF Cross table with many to one table relationship in DAX Commands and Tips

DATEDIFF Cross table with many to one table relationship

kdaya — Wed, 14 Aug 2019 14:45:52 GMT

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

days

thanks in advance

Re: DATEDIFF Cross table with many to one table relationship

Anonymous — Wed, 14 Aug 2019 18:05:28 GMT

-- 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