Need help with creating a column with multiple criteria

[Anonymous]

I want to create a new coulmn that shows freight costs by using two precentages (10% and 5%) based on cost per unit. 

This new column will be based on three coulmns:
Category (1,2,3)
Document type (A,B,C)
Cost per unit (Values)

I want that all the rows in this column should show only Document type "A".
After that I need the new column to show that Cost per unit is multiplied by 10%(0,1) if its Category 1 and 2. If its Category 3 I want Cost per unit to be multiplied by 5%(0,05).

Something like this:

Category	Document type	Cost per unit	New Column (Freight)
1	A	10	1
3	A	100	5
3	B	10	-
2	A	100	10
1	C	10	-
1	B	10	-
2	A	10	1
3	A	1000	50
3	C	10	-

Cant figure out how to write this formula, so I appreciate any help!

[AlB · Accepted solution]

Hi @Anonymous 

Create this calculated column:

New column =
IF (
    Table1[Document Type] = "A",
    IF (
        Table1[Category] IN { 1, 2 },
        0.1 * Table1[Cost per unit],
        IF ( Table1[Category] = 3, 0.05 * Table1[Cost per unit] )
    )
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers