Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

[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== ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks!! this worked!