Conditional Calculated Column

Anonymous — Wed, 15 Jun 2022 19:14:01 GMT

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

Re: Conditional Calculated Column

Anonymous — Wed, 15 Jun 2022 19:53:51 GMT

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

topic Re: Conditional Calculated Column in DAX Commands and Tips

Conditional Calculated Column

Re: Conditional Calculated Column