Forum Discussion
Solved
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 the...
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 AllanBerces
Try this calculated column:
IF(
'table'[Location] = "Project",
'table'[Trade],
'table'[Location]
)