IF Else statement for custom column

[Anonymous]

Hello,

I will like to make an if else statement in a column (which already consist of a custom made averaging formula) which i will call it column C

Prior to this, I have column A and I have numbers in Row 1 to Row 10

After which, I have column B with numbers in Row 1 as well as null in certain Rows leading to Row 10 

Where and how do I put in the if else statement in column C such that my output (in column C) will be

if Column A Row 1 (for example) has numbers and Column B Row 1 has numbers, Column C will be the average of column A Row 1 and column B Row 1 (this is the average formula i mentioned earlier)

else Column A Row 2 has numbers and Column B Row 2 has null , Column C will be equal to the numbers in Column A Row 2

I hope I am clear in explaining the above.

Let me know if you need further clarity

[ryan_mayu · Accepted solution]

@Anonymous 

I am not sure if I totally understand your question. Please see if below info is helpful.

Column = if(ISBLANK('Table'[B]),'Table'[A],('Table'[A]+'Table'[B])/2)

[Anonymous]

Thank you for solving my problem 😀

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.