Forum Discussion
Problems with syntax in combination with Related
What does the relationship look like? I suspect it has to do with cross filter direction.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
Thta is interesting. So it can matter from which table the relationship is created?
BartVlek Not really from which table the relationship is created, but the cross filter direction.
To simplify things, if the arrow does not point to the total table, you will not be able to pull discount columns into a calculated column in total table using RELATED. If the chain of relationships goes through another table, the arrows always have to point to the total table.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
I am certain the relationship is created correctly.
The syntax error I keep receiving is: Syntax error: expected IN this is after the final bracket
