Forum Discussion
Left join with three tables
I have three tables, T1, T2 and T3. T2 has relation with T1 and T3 but T1 and T3 don't have any relation. How can I convert the following SQL to DAX: SELECT
t2.col1
,FORMAT(SUM(CAST...
Thanks xifeng_L
I'm totaly new in DAX. I checked it and the relationships are one-to-many:
T2 -> T1 is one-to many
T2 -> T3 is one-to-many
and T1 and T3 doesn't have any relationship.
When I use the dax code you suggested getting this error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
xifeng_L
Super User
Super User
I'm guessing you're using either the measure or the calculated column option? Both of these options need to return scalar values, whereas I gave you the expression to create a table. Obviously, a table can't fit into a cell. So you should use the "New Table" option.
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~