Financial analysis: How to make calculation that meets certain condition with nested if statement

Power Query
1

Hi all,

I have a financial calculation problem to ask and would appreciate any kind help!

In the table attached, AA_100010 and AA_100020 are empty numbers. They are values from additions of other cells.

Financial calculation
Financial calculation1116×594 85.7 KB

What I would like to have is creating a new column in Power Query where

IF [AACT_NUMBER]= AA_100010 Then [New Value] is AA_100011+AA_100014 which equals to 17

ELSE IF [AACT_NUMBER]= AA_100020 Then [New Value] is AA_100021 + AA_100023 which equals to 26
ELESE Return values in the [VALUE] column

Thanks in advance for the help from Taiwan!

2

Hi @laurencesu

Create a conditional column

image
image1353×158 21 KB

image
image833×277 10.5 KB

1 Like
3

Welcome to the forum, @laurencesu :slight_smile:

We hope that the answer above helped you.

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

4

Thanks Rajesh for looking into this problem, this was exactly what I was looking for : )