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, 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:
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.
3 Replies
- Mariusz
Community Champion
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.
PhoenixBird66No 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
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.