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