I've been giving this some more thought. fxGroupCompReturn should calculate compounded returns by group. Its inputs should be, return (Gain x po...
Thanks Catalin, its really great to have the code broken down like this. I'm now confused by something else though. When calling the function fx...
Thank you for your step by step solution Catalin, so helpful. This is my first attempt at custom functions (and List.Generate) and it's been quite ...
Well, I'm certainly learning a lot here! Thanks very much Velouria and Riny
Thank you, You've been very helpfull, that looks like it works the way I'd like. I'll keep studying and doing examples, hopefully it will start ...
Hello again, I'm now practicing with some data over 3 years. The formulas, as they are, work properly on the first year of data but give the wro...
I'm on current channel so I guess I should be up to date. I shall try doing an uninstall/reinstall over the weekend, see if that solves it.
Thank you again, The FILTER solution worked. However, I've ran an update but your original solution still produces an error. It's a bit baffl...
Here are some photos of my screen. I couldn't get screenshot to work in excel for some reason. The first is the pivot table error message. After cl...
Hello Riny, I've tried to copy your example (see attached) and it went ok until I got to the compounded%YTD measure. This produces an error and ...
Thank you Riny, That looks just what I'm after. I've not used power pivot or the data model before. The actual data I am going to analyse wil...
Here's a table with some dates over 3 months with some percentages. The right hand column in the table shows the compounded total at the end of eac...
Nice one Riny! Thanks, Andy