IF condition

[AllanBerces]

Hi and good day,

Pls need help on my table to create calculated column or in PQ. What we required is 

-IF the location is Project type then used trade column value
-IF the location is MNT type then used the location value

DESIRED OUTPUT

Thank you

[danextian]

Hi @AllanBerces 

Try this calculated column:

IF(
    'table'[Location] = "Project", 
    'table'[Trade], 
    'table'[Location]
)

[rajendraongole1 · Accepted solution]

Hi @AllanBerces  - can you add a new column in power query editor steps:

Open Power Query Editor>>Select the table>>Click Add Column > Custom Column.

if [Type] = "Project" then [Trade] else [Location]

Click OK and rename the column to Output.Click Close & Apply.

Hope this helps.

[AllanBerces]

Hi @rajendraongole1 @danextian thank you very much for the reply, all good.