I have a power BI query that I run and pull into excel to review billing data. I have additional columns added to the end of the query that are vlookup formulas to pull data from another tab. When I refresh the data if there are more rows added it is not copying the vlookup formulas down.
Is there a way to set the properties so that when it refreshes it knows to copy the formula from the row above for any new rows?
If not, I was going to add a macro for the refresh and at the end add a copy function but to do that I would like it to find the last populated cell in column AW in order to tell it to copy the formula down to all remaining rows. Is there an easy way to do this?
Any/All feedback would be greatly appreciated
Is there a way to set the properties so that when it refreshes it knows to copy the formula from the row above for any new rows?
If not, I was going to add a macro for the refresh and at the end add a copy function but to do that I would like it to find the last populated cell in column AW in order to tell it to copy the formula down to all remaining rows. Is there an easy way to do this?
Any/All feedback would be greatly appreciated