Forum Discussion
Solved
Calculating 'In' and 'Out' Records
Hi all, I have a data table that looks like this: PERSONID EFFFROMDATE EFFTODATE TNFR_CC_CHANGE_IN DIM_FROM_RC_KEY DIM_RC_KEY 1003110 3/1/2018 3/31/2018 1 67400 68211 1003110 8/...
garynorcrossmmc , The two columns should join with a common dimension DIM_RC and there will be one inactive join, that can be activated using userelationship
example
CALCULATE(
SUM('Table'[personID]),USERELATIONSHIP('DIM_RC'[DIM_RC_KEY],'Table'[DIM_FROM_RC_KEY])
)
garynorcrossmmc , The two columns should join with a common dimension DIM_RC and there will be one inactive join, that can be activated using userelationship
example
CALCULATE(
SUM('Table'[personID]),
USERELATIONSHIP('DIM_RC'[DIM_RC_KEY],'Table'[DIM_FROM_RC_KEY])
)