Hi. I'm having a problem creating a measure that counts "How many children have had a visit within 14 days after homecoming" In my model I have one fact table with the "homecoming" events and another fact table with the visits.
In SQL I would have solved it by using Exists like this.
FROM FactVisit fv
f.D_Aktivitetskod_dKey = 10
AND fv.D_Barn_dKey = f.D_Barn_dKey
AND fv.VisitDate <= DATEADD(dd,14,f.HomecomingDate)