This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
hi,
i try to import a column from another table. my two tables are linked by this
but i cant take the function related.
do you know why? is there some condition to do this?
Thanks everyone
Solved! Go to Solution.
Change Cross filter direction to single.
hi,
m
i try to import a column from another table. my two tables are linked by this
but i cant take the function related.
do you know why? is there some condition to do this?
Thanks everyone
You can try to use RELATEDTABLE instead. RELATED is used to get data from the one side of relationship
they said
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Which table is on the many side and which one is onethe many side of relationship?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 21 | |
| 20 |