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

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors