I've been trying to write a custom function in power query but keep getting errors, I've decided on a running total,
so i can do that proved the column names are the the same ;
but this is no use if the column names are not 'unit' or whatever, so I tried the following for a percentage increase,Please Login or Register to view this content.
And I can select the query add colum; invoke custome function and put in whatever columns I need as current and prevoious, so thoght I should be able to do the same fort List.Sum( List.FirstN , the problem seems to be the source,Please Login or Register to view this content.
I've tried ;
and uiing 'Any' then thpe 'Source' in as that parameter, but no good, any suggestion,I've attached the workbook with attemps and errors.Please Login or Register to view this content.
Richard
Bookmarks