cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ellensantiago1 Regular Visitor
Regular Visitor

IF else statement with multiple condition

 

Hi Good Morning,

I have a formula from excel that I can't seem to find a way to put in my formula in power BI. Sorry not really sure on how power BI works till now. 
here's the formula : = =SUM(AH2:AK2,AN2)+IF(AF2="O",AO2,0). Anyone can help to solve this pls?

here's the table:

test3423.JPG=SUM(AH2:AK2,AN2)+IF(AF2="O",AO2,0)

1 ACCEPTED SOLUTION

Accepted Solutions
HotChilli New Contributor
New Contributor

Re: IF else statement with multiple condition

In Power Query, add a custom column. 

 

[AH] + [AI] +   any other columns     + (if [AF2] = "O" then [AO2] else 0)

 

Make sure that the columns have the correct datatypes

View solution in original post

1 REPLY 1
HotChilli New Contributor
New Contributor

Re: IF else statement with multiple condition

In Power Query, add a custom column. 

 

[AH] + [AI] +   any other columns     + (if [AF2] = "O" then [AO2] else 0)

 

Make sure that the columns have the correct datatypes

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 286 members 3,427 guests
Please welcome our newest community members: