Forum Discussion
Power Query formula
Question 1: In Column H is a simple formula to show the variance between columns G and F. How can I show a "null" in H when there is nothing in G? Question 2: Column F has a simple formula that ...
Rex-Delson
Answer 1: You can use IF funtion, if the Column G has no value.
=IF(G1="","null",G1-F1)
Answer 2: Use the UNDO or CTRL+Z (twice) or, once it automatically copied the formula you typed, an icon will appear once you press the ENTER. Click on that Icon, and it will show an options, then simply choose "Stop Automatically Creating Calculated Columns"
Thank you. Apparently there's a way to do this within Power Query. Do you know how?