Forum Discussion

smacsween's avatar
smacsween
Frequent Visitor
5 years ago
Solved

Conditional merge columns

i am trying to merge columns based on an IF statement and ISBLANK.  If I have Country name in Table1, use that value, if not, use the Country value from Table2.   I can't see how to do this, I have...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi smacsween ,

     

    Just try this:

    NewTable =
DISTINCT (
    UNION ( DISTINCT ( Table1[Country] ), DISTINCT ( Table2[Country] ) )
)

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

smacsween's avatar
smacsween
Frequent Visitor
5 years ago

It's two text columns I want to merge so actually a measure is probably not the thing I should have tried, it should just be a new column.  What would be the corresponding formula for a text merge based on that scenario?

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

It's a calculated column?  If so, take off the MIN( ) for whichever table you are putting it on.  For example, if adding the column to Table 2,

 

OfficeCombined =
IF (
isblank(MIN ( 'Table1'[Country] ) ),
Table2[Country] ,
MIN ( 'Table1'[Country] )
)
 
Regards,
Pat