DAX help - Custom column should be null if a value in another column is null

[PhoenixBird66]

I have created a custom column (StdSvcKey) which is concatentation of two other columns (Sell-to Customer No. & Standard Service Code).

Currently if the Standard Service Code has a null value, but the Sell-to Customer No. field is not blank, my new custom column shows the contents of the Sell-to Customer No. field.  I need it to show as null if there is nothing in the Standard Service Code.

This is what I need it to look like:

But currently I'm getting this:

[Mariusz]

Hi @PhoenixBird66 

Try 

Measure = IF( NOT ISBLANK( YourTable[Standard Service Code] ), Concatenate expression )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[PhoenixBird66]

No sadly that didnt work. It still returns the value from the Sell-to Customer No. field. I want it to be null if the Standard Service Code field is null.

This is the DAX i used:

Measure = IF( NOT ISBLANK( Query1[Standard Service Code] ), Query1[Sell-to Customer No.]&Query1[Standard Service Code])

[Mariusz · Accepted solution]

Hi @PhoenixBird66 

The below will handle nulls and ""

Column = 
IF( 
    NOT( ISBLANK( 'Table'[Standard Service Code] ) || 'Table'[Standard Service Code] = "" ),
    'Table'[Sell-to Customer No.] & 'Table'[Standard Service Code]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.