cancel
Showing results forĀ
Search instead forĀ
Did you mean:Ā
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

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.

5 REPLIES 5
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.

Helper II

Hey FMX thanks alot for the help so far

I am getting an error with this formula though

Any ideas?

Helper I

Check your "," and ";".

Helper II

Great that worked!

Thank you sir

Helper I

## Helpful resources

Announcements

#### Happy New Year from Power BI

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

#### Check it Out!

Click here to read more about the December 2020 Updates!

#### 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

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

Top Solution Authors
Top Kudoed Authors