cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

IF function with multiple conditions

Hello everyone

I'm trying to build up some calculation like this for a visual of stock management between multiple warehouses

 

Table: Butikk
Columns: Warehouse number, item, Itemclass, sales code

 

column1 = IF('Butikk'[Itemclass]) equals 2 and ('butikk'[sales code]) equals  7 or 8 or 99
then "True" els "false"

column2 = IF('Butikk'[itemclass]) equals 1 and ('butikk'[sales code]) equals 1 or 2 or 3 or 4 or 5
then "True" els "false"

Result = IF('Butikk'[column1]) equals "true" and ('butikk'[column2]) equals "true" then "True" els "False"

 

Now i also need it to tell me if a warehouse has the item as false, i want it to show me what warehouse has it in true.
So that warehouse can ship it to the other. If the item class 1 and has a sales code betwene 1-5 it means it sels well. item class 2 and 7,8,99 means its bad

 

Warehouse numbers
L10, L20, L30, L40, L50, L60

 

I just wrote this so illustrait what im trying to do, i am very new to writing DAX. So any help would be amazing 🙂

1 ACCEPTED SOLUTION
Helper I
Helper I

 

Make a Calculated Column:

column1 =
IF(
AND( 'Butikk'[Itemclass]' = 2, 'Butikk'[sales code] = 7 || 'Butikk'[sales code] = 8 || 'Butikk'[sales code] = 9
), "True", "False"
)

column2 and Result, same concept.

 

For the warehouse part, you're gonna have to put in more context on defining the problem.

View solution in original post

5 REPLIES 5
Helper I
Helper I

 

Make a Calculated Column:

column1 =
IF(
AND( 'Butikk'[Itemclass]' = 2, 'Butikk'[sales code] = 7 || 'Butikk'[sales code] = 8 || 'Butikk'[sales code] = 9
), "True", "False"
)

column2 and Result, same concept.

 

For the warehouse part, you're gonna have to put in more context on defining the problem.

View solution in original post

Hey FMX thanks alot for the help so far

I am getting an error with this formula though

Any ideas?

12345.png

Check your "," and ";".

Great that worked!

 

Thank you sir

Helper I
Helper I

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors