Forum Discussion

zgardner7's avatar
zgardner7
Regular Visitor
8 years ago
Solved

Create Parent IDs via a Calculated Column in DAX

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

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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