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...
Need Help
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.