Replace value in one field based on null field in another

[pbrainard]

So I think what I'm wanting to do is straight forward,  but it's late and I'm suffering brain fog.

Want to create a measure (new column) that changes the varSENT value 'SENT' to 'SIGNED' if a date exists in the Signed On Column, and changes the varSENT value 'SENT' to 'UNSIGNED'  if the Signed On value is null. I don't want the blank values in varSENT changed.

[Anonymous · Accepted solution]

Hi  @pbrainard ,

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    MAX('Signatures'[Signed ON]) <> BLANK(),
    IF( [varSent] <>BLANK(),"SIGNED",[varSent]),"UNSIGNED"
)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[TomMartens]

Hey @pbrainard,
try this measure:

Measure = 
if( hasonevalue( 'yourtablename'[Signed On] )
, if( isblank( 'yourtablename'[Signed On] )
    , "unsigned"
    , "signed"
  )
, blank()
)

Hopefully, this provides what you are looking for.

Regards,

Tom

[pbrainard]

Thanks Tom,

Getting an error: A single value for column 'Signed On' in table 'Signatures' cannot be determined....

This is how varSENT is built:

varSENT =
VAR SENT = SELECTEDVALUE('Signatures'[Status])
RETURN IF(SENT = "SENT", SENT, "")

[TomMartens]

Hey @pbrainard ,

use this one:

Measure = 
if( hasonevalue( 'yourtablename'[Signed On] )
, if( isblank( calculate( max( 'yourtablename'[Signed On] ) ) )
    , "unsigned"
    , "signed"
  )
, blank()
)

If you are wondering why I'm using MAX around the column reference, it's because there is no ROW context for this reason a column reference has to be wrapped inside an aggregation function like MAX.

Regards,

Tom

[pbrainard]

Now everything in the Measure column has a value of 'signed'

[TomMartens]

Hey @pbrainard ,

I added a CALCULATE. This is necessary use the current filter context.

Regards,

Tom