Forum Discussion
circular dependency --help please
hi i am just trying to relate tables using bridge table . where i am facing the circlaur dependency . dim: feedyard sex ration data table : feedyard sex ration index alex bike 1200 0...
Hi Anonymous
1. copy "dimension" and paste, then i get "dimension2" table,
in this table with only one column, "remove rows"->remove duplicates
2. copy "data" and paste, then i get "data2" table,
in this table, click on the [index] column and select "Remove other columns", then Removed Duplicates
3.in "dimension2" table, add a custome column
Then expand this column
Best Regards
Maggie
3.in Query1:
Add column from Query2 , then expand the column .
can you send me screenshot how you did this from query editor . I am not able to add column from another table .can you help here ?
hi v-juanli-msft if you used custom calculation tab for adding column .if yes can you share code please?