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== Blank(),
(Fields!DriftCorrection_pH7Value.Value +Fields!DriftCorrection_pH10Value.Value)/2.0,
(Fields!DriftCorrection_pH7Value.Value +Fields!DriftCorrection_pH4Value.Value)/2.0)
I appreciate your help in advance,
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)
4 Replies
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, not sure about all the exact table and column name you have, however what I can see your measure starts with iif. As per my understanding, there is nothing iif, can you please change it to IF.
If this resolves your problem, then please make it as solution, Thanks
