cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zgardner7 Frequent Visitor
Frequent Visitor

Create Parent IDs via a Calculated Column in DAX

Hello,

 

I have data in the following format:

initialData.PNG

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.

finalData.PNG

Any assistance would be greatly appreciated!

 

Best,

 

ZG

1 ACCEPTED SOLUTION

Accepted Solutions
rajendran Super Contributor
Super Contributor

Re: Create Parent IDs via a Calculated Column in DAX

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 :

Parent.PNG

 

Thanks
Raj

2 REPLIES 2
rajendran Super Contributor
Super Contributor

Re: Create Parent IDs via a Calculated Column in DAX

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 :

Parent.PNG

 

Thanks
Raj

zgardner7 Frequent Visitor
Frequent Visitor

Re: Create Parent IDs via a Calculated Column in DAX

Thank you!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 268 members 3,092 guests
Please welcome our newest community members: