79078907

Date: 2024-10-11 15:47:39
Score: 0.5
Natty:
Report link

I recommend a relationship on the IDs between the two tables.

data model

Then on the Table_start Table, create a calculated column:

date diff = 
VAR startDate = Table_start[startDate]
VAR endDate = RELATED(Table_end[endDate])

RETURN DATEDIFF(startDate, endDate, DAY)

Create a measure to get the average:

average days = AVERAGE(Table_start[date diff])

Result:

result

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
Posted by: Nick A