Forum Discussion

asfasfgasfg's avatar
asfasfgasfg
Frequent Visitor
2 years ago

column unknown error

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" )

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      asfasfgasfg
      Frequent Visitor
      2 years ago

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