Hi guys,
New to this forum but moderate/advanced Excel knowledge, (Little VBA however).
I am struggling with something which might be incredibly easy.
I have source data from my SQL, through Power Query and i have added columns on to the generated table to include a SUMIFS which calculates Sales Figures based on 3 different criteria's.
However, when i click Refresh it REF's the field which was allocated in the table.
See below formula before and after
Bookmarks