Forum Discussion
procyon82
Resolver I
Resolver IUsing RELATED()
Hi, I only recently installed Power BI and I've been testing it for a few days. So far so good except that I am combining data from two different Google Analytics UA- tracking codes and I'm runni...
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.
procyon82Resolver I
Resolver IThanks! 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
Resident RockstarYou 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.