Change formula to an if statement

[gheyman]

Is it possible to change this to an if statement? Or do I need to add a column and then remove to do this?

= Table.ReplaceValue(#"Renamed Columns",null,"SQID",Replacer.ReplaceValue,{"Category"})

I need an if statement that says if [Source Id] is null then...

Thanks!

 

[JGordon11]

This changes any nulls in the Category column to SQID if the value in Source Id is null, if Source Id isn't null then the null in Category column is unchanged.

= Table.FromRecords(Table.TransformRows(#"Renamed Columns", each if _[Source Id] = null and _[Category] = null then 
Record.TransformFields(_, {"Category", each "SQID"}) else _), Table.ColumnNames(#"Renamed Columns"))

 

[gheyman]

THNAK YOU!!