Forum Discussion
Resolver IUsing RELATED()
The relationship between ecommerce and Traffic is one -> many.
Which means that for each row in ecommerce you can have more than one row in traffic.
Therefore, you must use RELATEDTABLE instead of related, And since this is going to return more than one row , You should wrap it in an aggregation function.
Advocate IIThe relationship between ecommerce and Traffic is one -> many.
Which means that for each row in ecommerce you can have more than one row in traffic.
Therefore, you must use RELATEDTABLE instead of related, And since this is going to return more than one row , You should wrap it in an aggregation function.
procyon82Thanks! That's helpful. Can you elaborate on the aggregate function? I looked it up and none (https://msdn.microsoft.com/en-CA/library/ms173454.aspx) work for my purposes.
- deldersveld
Resident Rockstar
You linked to a T-SQL page. Try the DAX reference instead: https://msdn.microsoft.com/en-us/ee634396.aspx
Sum/SumX, etc. are aggregation functions.
