Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I woul like to know how to join two tables that I get with SUMMIRIZE function. Tables doesn't have a direct relationship, they only connected by common dimensions.
For example, I have the code that doesn't work:
var table1 = SUMMARIZE(
FactTable1,
FactTable1[CustomerId],
FactTable1[DateId],
FactTable1[CategoryId],
FactTable1[Amount]
)
var table2 = SUMMARIZE(
FactTable2,
FactTable2[CustomerId],
FactTable2[DateId],
FactTable2[CategoryId],
FactTable2[AmountWithDifferentName]
)
return NATURALLEFTOUTERJOIN(table1, table2)
And the execution of this code throws an error message: "No common join columns detected. The join function requires at-least one common join column."
Hi
My Issue got resolved by using groupby DAX function.
Thanks,
@Anonymous , see if this can help
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Hi @Amit ,
I too got the same error with the same kind of scenario. Below is part of my code.
Thanks
try changing the name to be a common name between the two columns in the tables to be joined.
NATURALLEFTOUTERJOIN function (DAX) - DAX | Microsoft Learn
Hi
Thanks for the reply.
I did try by changing the name of the columns to same in both the cases.
Still no luck.
Error: The incompatible join column was dectected.
Couldn't figure out why this error comes, even I have same datatypes,names for both the columns.
Thanks