cancel
Showing results 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 Helper II

Great that worked!

Thank you sir Helper I   