Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 :)

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

     

    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