Forum Discussion
IF condition
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
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.
3 Replies
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.
Hi rajendraongole1 danextian thank you very much for the reply, all good.
Hi AllanBerces
Try this calculated column:
IF( 'table'[Location] = "Project", 'table'[Trade], 'table'[Location] )
