Conditional Calculated Column

[Anonymous]

Hey everyone,

I need help with a calculated column.

I've got two tables. Table one contains the hours employees have worked (Aantal), which project they have worked for (Klantnum.), which role they have. (Personeel.Tarief Categorie)

An employee is either an advisor or a coördinator.
Both have different hour rates. The rates differ per customer (Klantnum.)
These rates are present in second table.

I want to add a calculated column to the first column which does the following:
If Klantnum. is not null:
If Personeel.Tarief Categorie = Adviseur, Aantal * Table2.Tarief adviseur
If Personeel.Tarief Categorie = Coördinator, Aantal * Table2. Tarief coordinator
If Klantnum. is null: 
Null

With kind regards,

Lazzanova

[Daryl-Lynch-Bzy · Accepted solution]

@Anonymous - in Power Query, you can add a Custom Column using the following if syntax.

if [Klantnum] = null then null 
esle if [Personeel.Tarief Categorie] = "Adviseur" then [Aantal] * #"Tarief Adviser" 
else [Aantal] * #"Tarief coordinator" 

The rates need to be added Query

Tarief Adviser = let source #"Table2"{0}[Tarief adviseur]  in source 
Tarief coordinator = let source #"Table2"{0}[Tarief coordinator]  in source