Dear all,
If anyone knows how the following calculation can be done in Power Query M Code, that would be very much appreciated:
NAV Diff 4733891,955 =WENNFEHLER(F5/F6-1;"") 4733891,955 =WENNFEHLER(F6/F7-1;"") 4733891,955 =WENNFEHLER(F7/F8-1;"") 4733891,955 =WENNFEHLER(F8/F9-1;"") 4394687,895 =WENNFEHLER(F9/F10-1;"") 4296264,18007194 =WENNFEHLER(F10/F11-1;"") 4394687,895 =WENNFEHLER(F11/F12-1;"") 4296264,18007194 =WENNFEHLER(F12/F13-1;"") 4394687,895 =WENNFEHLER(F13/F14-1;"") 4296264,18007194 =WENNFEHLER(F14/F15-1;"") 4394687,895 =WENNFEHLER(F15/F16-1;"")
This is just an example ("WENNFEHLER" means "iferror"). The table will have a column "NAV" with an arbitrary number of rows sorted by Date so that the most current date will always be in the first row. I would like that the custom column shows the percentage change from date to date (row to row). In this example the result would look like this:
NAV Diff 4733891,955 0% 4733891,955 0% 4733891,955 0% 4733891,955 8% 4394687,895 2% 4296264,180 -2% 4394687,895 2% 4296264,180 -2% 4394687,895 2% 4296264,180 -2% 4394687,895
In general I have difficulties to understand the principle of this kind of calculation in M Code.
Many thanks,
Kai