Forum Discussion
IF and RELATED functions
I want to create a new column in Buildings table which gives: the country name, if it can find a related value in the Countries table; or Other otherwise. Buildings table is related with Countrie...
Based on your description i'd be expecting something like this:
YourFieldsName = VAR countryCode = FIRSTNONBLANK(Countries[Code], Countries[Code]) RETURN IF( ISBLANK(countryCode), "other", countryCode )
Hi,
I get an error: Token Eof expected