Forum Discussion
PhoenixBird66
Helper III
Helper IIIDAX help - Custom column should be null if a value in another column is null
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, bu...
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.
PhoenixBird66Helper III
Helper IIINo 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
Community Champion
Community Champion
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.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.