Return value of a column if another column is null/blank?

[slatka11]

Hi there,

I have the below 3 columns all in the same table (call it TABLE_1) and I am looking to return the value of one column if the other is blank:

Month	Projected Rate	Actual Rate
December	1.35	1.34
January	1.35
February	1.35

What I am looking to acheive is that if the value in the "Actual Rate" column is blank, return the value in the "Projected Rate" column.

Thanks for your help.

[slatka11]

Thank you very much

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula

=if(isblank(Data[Actual rate]),Data[projected rate],Data[Actual rate])

See if this shorther calculated column formula works as well

=coalesce(Data[Actual rate],Data[projected rate])

Hope this helps.