Filling Empty Cells in Gross Annual Salary Column

[INN]

Hi,

I have a table with three columns: Country, Annual Salary, and Gross Annual Salary. Some cells under the Gross Annual Salary column are empty. How can I fill these cells with the same values as those in the Annual Salary column? using power Q. Thank you.

 

[RoryA]

Simple way is to add a new calculated column using something like:

=if [Gross Annual Salary] = null then [Annual Salary] else [Gross Annual Salary]

then remove the original Gross Annual Salary column.

 

[johnny51981]

Simple way is to add a new calculated column using something like:

=if [Gross Annual Salary] = null then [Annual Salary] else [Gross Annual Salary]

then remove the original Gross Annual Salary column.

I'd update to

=if [Gross Annual Salary] = null or [Gross Annual Salary] = "" then [Annual Salary] else [Gross Annual Salary]

in case it isn't truly null.

 

[INN]

Thank you all, can that be done without writing M language code? Thank you again.

 

[RoryA]

Not really, why? Anything you do in PQ is using M code.

 

[johnny51981]

I mean...a Find and Replace in your data prior to refreshing your queries, but that is too manual for my taste.