Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may have a look at this article to understand circular dependency.This article is about avoiding circular dependency. For your case,i would suggest you create measures or create the column in query editor to avoid circular dependency.If you need further help,please share the .pbix file and explain more about your expected output.You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may have a look at this article to understand circular dependency.This article is about avoiding circular dependency. For your case,i would suggest you create measures or create the column in query editor to avoid circular dependency.If you need further help,please share the .pbix file and explain more about your expected output.You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Regards,

Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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