where clause in DAX for custom column

[Anonymous]

Hello,

I want to make a new column with the values based of a existing column. At the moment I have the following columns: 

1. 'TypeWorkTime' with two values: planning and realtime

2. 'Time'

So I want to make 2 new columns called planning and worktime with the values of Time, I have tried the following DAX formula but I am doing something wrong.

Planning = 'Trello cards'[Time] ; 'Trello cards'[TypeWorkTime] = "Planning"

Thanks,

Shabby

[Gordonlilj · Accepted solution]

Hi,

Does this give the result you're asking for?

Planning =  IF('Trello cards'[TypeWorkTime] = "Planning";'Trello cards'[Time])

[Anonymous]

Thanks! It worked perfectly, I did not know u could use 'if' in dax.