column folmula
App-Ref Lag = Applications[Reference Date]-Applications[Application Date]
based on 2 columns
Application Date = CALCULATE(MAX('Candidate Journey'[Activity Date]),
FILTER(RELATEDTABLE('Candidate Journey'),
'Candidate Journey'[Journey Stage]="Website Application to Review" ||
'Candidate Journey'[Journey Stage]="Incomplete Application"))
and
Reference Date = CALCULATE(MIN('Candidate References'[Activity Date]),
FILTER(RELATEDTABLE('Candidate References'),
'Candidate References'[Status/Outcome]="Reviewed - Suitable"
),
USERELATIONSHIP(Applications[Application ID],'Candidate References'[Application ID]))
i had an active relationship in application date so turned it off and tried
Application Date = CALCULATE(MAX('Candidate Journey'[Activity Date]),
FILTER(RELATEDTABLE('Candidate Journey'),
'Candidate Journey'[Journey Stage]="Website Application to Review" ||
'Candidate Journey'[Journey Stage]="Incomplete Application"),
USERELATIONSHIP(Applications[Application ID],'Candidate Journey'[Application ID])
)
which then gave me a circular dep in that formula as well
Now all relationships are inactive. compeltely stumped. Any advice appreciated
