cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## Custom column from another created using PATH

Dear all,

I have this data below, shown in the picture. The original data is from columns [parent] and [child]. I created [Contas] using PATH([child];[parent]), but I have another fact table that this PATH is in a different format, which I tried to recreate in [Contas (Planilhas)] using the formula below:

```Contas (Planilhas) = IF([Length]=12;MID([Contas];1;1);
IF([Length]=25;MID([Contas];1;1) & "|" & MID([Contas];15;1);
IF([Length]=38;MID([Contas];1;1) & "|" & MID([Contas];15;1) & "|" & MID([Contas];29;2);
IF([Length]=51;MID([Contas];1;1) & "|" & MID([Contas];15;1) & "|" & MID([Contas];29;2) & "|" & MID([Contas];44;2);
IF([Length]=64;MID([Contas];1;1) & "|" & MID([Contas];15;1) & "|" & MID([Contas];29;2) & "|" & MID([Contas];44;2) & "|" & MID([Contas];59;2);
IF([Length]=77;MID([Contas];1;1) & "|" & MID([Contas];15;1) & "|" & MID([Contas];29;2) & "|" & MID([Contas];44;2) & "|" & MID([Contas];59;2) & "|" & MID([Contas];74;2);
"fazer"))))))```

However, when I try to add the relatioship to the other table, I get an error saying I have a "Circular Dependency" from this table.

Any sugestions on how I could get this changed column in a better and smarter way, and why this is a Circular depent formula?

Thank you,

Eduardo

1 ACCEPTED SOLUTION
Employee

Hi @Anonymous

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Employee

Hi @Anonymous

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thank you. I was able to create what I needed from the Query Editor, and then used PATH functions / relationships successfully.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors