Forum Discussion

MarcUrdang's avatar
MarcUrdang
Post Patron
6 years ago

Related Function

We would like some help on the following: How to use a field in one Table in a second Table for example: We have one Table showing airlines with their related codes ie: column1 =SAA , column 2 = 123....
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi MarcUrdang ,

 

After my test, you could refer to the following DAX:

Column =
IF (
    'Table 2'[3digits]
        = CALCULATE (
            SELECTEDVALUE ( Airline[Column2] ),
            ALLEXCEPT ( Airline, Airline[Column1] )
        ),
    "y",
    "n"
)

 

MarcUrdang's avatar
MarcUrdang
Post Patron
6 years ago

Wow .. this seems to work .. thanks so much ...

 

However if I want to replace the "y" and the "n" with a table column is that possible? It does't seem to accept.

 

I can mail you the excel workbook and PBI file to show you what I mean .. not sure if you happy to send out your mail address.

 

thanks
Marc