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.
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