Forum Discussion
ld17
3 years agoHelper II
Circular Dependency Error
I'm working on a project that required me to cross join two tables ("Names and Job Titles" and "Course List") to form a new table called "Table 2." From there, I created a calculated column calle...
- 3 years ago
ld17 , Change this like
Table 2 = CROSSJOIN ( Distinct ('Names and Job Titles'[Associate.title]), Distinct ( 'Course List'[Title]))
and try
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak
3 years agoSuper User
ld17 , Change this like
Table 2 = CROSSJOIN ( Distinct ('Names and Job Titles'[Associate.title]), Distinct ( 'Course List'[Title]))
and try
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- ld173 years agoHelper II
Thank you SO much! That works perfectly.