Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Herson
Regular Visitor

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

Hi all,

 

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

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

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 

Herson_3-1638458446537.png

 

Thanks in advance for the help from Taiwan!

 

 

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

2 REPLIES 2
wdx223_Daniel
Super User
Super User

wdx223_Daniel_0-1638510078304.png

 

Thank you Daniel : )

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors