Forum Discussion
[BC30201] Expression expected
Hi all, I am trying to run the following expression in POWER BI but I get this error: [BC30201] Expression expected Here is the expression: =iif ( Fields!DriftCorrection_pH4Value.Value== ...
Hi samratpbi ,Thanks for the quick reply.
Hi Anonymous ,
Regarding your question, there may be a problem in checking whether the field value is null or not. You can try to use 'IsNothing' instead of '== BLANK()' for null value determination. Change your expression:
IIF(IsNothing(Fields!DriftCorrection_pH4Value.Value),
(Fields!DriftCorrection_pH7Value.Value + Fields!DriftCorrection_pH10Value.Value) / 2.0,
(Fields!DriftCorrection_pH7Value.Value + Fields!DriftCorrection_pH4Value.Value) / 2.0)
Hi, Thanks, I did it. unfortunately, it is still the same.