IF function with multiple conditions

[Anonymous]

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 🙂

[Anonymous · Accepted solution]

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.

[Anonymous]

Hey FMX thanks alot for the help so far

I am getting an error with this formula though

Any ideas?

[Anonymous]

Check your "," and ";".

[Anonymous]

Great that worked!

Thank you sir

[Anonymous]

Looks like what you need is a nesting of SWITCH(), IF(), AND(), and OR() on a calculated column.

https://msdn.microsoft.com/en-us/library/gg492166.aspx

https://msdn.microsoft.com/en-us/library/ee634824.aspx

https://msdn.microsoft.com/en-us/library/ee634824.aspx

https://msdn.microsoft.com/en-us/library/ee634951.aspx