Create Parent IDs via a Calculated Column in DAX

[zgardner7]

Hello,

I have data in the following format:

I need to create a parent child relationship. Source A is transformed into Target B. There is no transformation occuring before this, so the first row will not have a parent ID. In the second row, the source is B, which was the target of the first transformation in the table, so I want the parent ID to be 1 for this row. My desired outcome is shown below.

Any assistance would be greatly appreciated!

Best,

ZG

[Anonymous · Accepted solution]

Hi @zgardner7

Try this

ParentID = 
VAR inCalc = CALCULATE(MIN('Parent'[ID]),FILTER('Parent','Parent'[Target]= EARLIER('Parent'[Source])))
RETURN
IF(ISBLANK(inCalc),0,inCalc)

Output is :

Thanks
Raj

[zgardner7]

Thank you!