column unknown error

[asfasfgasfg]

Can anyone explain to me why I can't use this column?

And how I can change the measure?

RWS/OWB =

IF ( 'LCM EC EXCEL'[RWS]  <> "RWS" ,

    SUBSTITUTE( 'LCM EC EXCEL'[RWS] , 'LCM EC EXCEL'[RWS] , "OWB") ,

    "RWS" )

[asfasfgasfg]

anyone?

[Anonymous]

Hi @asfasfgasfg ,
According to your description and the provided dax logic, you are trying to realize that if "LCM EC EXCEL"[RWS] is null, then this formula will return "OWB", otherwise "RWS ". In your formula, what you are returning after isblank is a boolean value and what you are comparing is a text value. To accomplish this while making sure your data type is text, here is a modification to your dax expression：

RWS/OWB = IF(
    ISBLANK('LCM EC EXCEL'[RWS]),
    "OWB",
    "RWS"
)

Best regards,

Albert He

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

[asfasfgasfg]

The column [RWS] is filled with RWS and many other values. I have no null values.