Power query using let statement

[Dicken]

Hi is there a way to defince different part of a calucaltion using let ;

example I have the a number from the previous row ;

Please Login or Register  to view this content.

and would like to divide this by the same column number in the current row, just using / [Row] does not work, so I wanted to do something like

Please Login or Register  to view this content.

[rorya]

Seems overly complicated when all you need for that column is:

Please Login or Register  to view this content.

[Dicken]

Hi Rorya
Well, I was more interested in how to do it rather than it being the best way of posting. Is it possible to have multiple let and in statements to use? I'm pretty certain it is only I keep getting an error.


Richard

[rorya]

Why do you want multiple let statements when all you need is one, since each step is already a variable - i.e.

Please Login or Register  to view this content.

[Dicken]

Well I thought I'd seen it done, so thought I'd try.

Perhaps it's not possible, i just thought it might prove useful, I spent a lot of time using iterative formulas in excel which I didn't have much use for but later proved very useful in a job I had.
RD

[rorya]

I don't see the connection to iteration. Are you referring to recursion, which is very different from your example?

[Dicken]

Sorry, no I wasn't, just the point that sometimes things for which don't seem much use turn out to useful at some future date.

RD