Forum Discussion
Rex-Delson
Jan 25, 2023Copper Contributor
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 ...
SergeiBaklan
Jan 26, 2023Diamond Contributor
By the way, if for returned by PowerQuery table you manually add data to new columns (e.g. Angel) the won't be synced on refresh, it doesn't work such way. Workaround is possible, depends on how do you build your data.