Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

0

BUG: NATURALJOINs and CROSSJOIN can't be used to create calculated table

Seems like there are more problems with NATURALLEFTOUTERJOIN, NATURALINNERJOIN and CROSSJOIN functions used to create calculatd table in PowerBI Desktop. When I have a relationship defined between "ItemID" columns, I get the error "The column with name ItemID already exists in 'Table' Table" but there is no such a table in the model. If I remove the relationship and even though I have "ItemID" named the same in both tables, I get the error that there are no common columns between the tables even though the documentation indicates that it will join on common column names. I tried both 1:1 and 1:* relationships. Also with Single and Both crossfilters. With CROSSJOIN with or without a relationship, I get the error that ItemID already exists. I tried both 1:1 and 1:* relationships. Also with Single and Both crossfilters. Both of my ItemID columns were whole number. I also tried as text. Same results. Can PowerBI team lookat it? It seriously deteriorating purpose of new PowerBI Feature to create calculated tables. Thanks
Status: Completed
Comments
chass
Impactful Individual
You can do joins on calculated tables for instance the DAX below works fine and both table and table2 are calculated tables. In order for it to work though i did have to rename the columns first. (TSQL enables you to specify and alias in the join syntax) Table 3 = CROSSJOIN('Table','Table 2')
fbcideas_migusr
New Member
Status changed to: Completed