Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Coalesce from two diffrent tables

Hi,   I am trying to create a calculated column to create COALESCE(SITEADDR.STADDRESS1,TRANSFIL.ADDR_VAT1) or If(Isblank(SITEADDR.STADDRESS1) ,TRANSFIL.ADDR_VAT1 , SITEADDR.STADDRESS1). but this is...
Need Help
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    You could try this:-

     

    column =
COALESCE ( SITEADDR[STADDRESS1], RELATED ( TRANSFIL[ADDR_VAT1] ) )

    or

    column =
IF (
    SITEADDR[STADDRESS1] = BLANK (),
    RELATED ( TRANSFIL[ADDR_VAT1] ),
    SITEADDR[STADDRESS1]
)

    Note:- I am considering you are creating a column in SITEADDR Table.

     

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous ,

 

You could try this:-

 

column =
COALESCE ( SITEADDR[STADDRESS1], RELATED ( TRANSFIL[ADDR_VAT1] ) )

or

column =
IF (
    SITEADDR[STADDRESS1] = BLANK (),
    RELATED ( TRANSFIL[ADDR_VAT1] ),
    SITEADDR[STADDRESS1]
)

Note:- I am considering you are creating a column in SITEADDR Table.