Forum Discussion
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...
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
The column [RWS] is filled with RWS and many other values. I have no null values.