Forum Discussion

Bibeksharma's avatar
Bibeksharma
Regular Visitor
8 years ago

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 Countries table via Countries' code column and Buildings' CountryCode

    I am thinking something along the lines of formula shown below but i am not quite sure.
    IF (
CONTAINS (RELATEDTABLE ([Countries]), Countries[Code]),

 

"other"
)



    Thank you.


Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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
)

     

    • Bibeksharma's avatar
      Bibeksharma
      Regular Visitor
      8 years ago

      Hi Daniel,
      The tables have  one to many relationship. 

       

      Thank you