Forum Discussion
BartVlek
6 years agoHelper II
Problems with syntax in combination with Related
I am having problems with getting the syntax right for the following expression: CostPrice = IF ( (RELATED ( 'discount'[percentage] ) = 0, ( 'total'[PAMP] ), ( ( 'total'[AMOUNT] ) * ( RELATED...
BartVlek
6 years agoHelper II
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
amitchandak
6 years agoSuper User
BartVlek , Share a screenshot of the error and final formula. If possible share pbix, after removing sensitive information.
- BartVlek6 years agoHelper II
I am not unwilling to that, but my PBI dashboard is all in Dutch ... I just translated for your understanding, but the syntax remains the same. How can I share a screenshot? Sorry very new to this