Thanks for your response, since I don't exactly know what calculated column means, I just added a picture of what I am trying to calculate (PH= expression) in the body of my post. Could you please check it again? Thanks
Hi everyone!
I am trying to run this query in DAX in PowerBI:
= iif (OR( [StationName.Value] = "CONGbann01", [StationName.Value] = "CONGccbr01"),
(Fields!DriftCorrection_pH7Value.Value + Fields!DriftCorrection_pH4Value.Value)/2.0,
Fields!DriftCorrection_pH7Value.Value...