Forum Discussion
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 cod...
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.
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.
Hey FMX thanks alot for the help so far
I am getting an error with this formula though
Any ideas?
Check your "," and ";".
Great that worked!
Thank you sir