如何从Power Query的上一行中获取列值? [英] How can I get a column value from previous row in Power Query?

问题描述

我想从上一行获取一个值.

I want to get a value from the previous row.

我尝试了这篇文章:

Table.AddColumn(#"Added index", "custom column", each {[Index]-1}[column name])

但是它抛出了这个错误:

But it throws this error:

Cannot use field access fot type List

请帮助，我在做什么错了?

Please help, what am I doing wrong?

推荐答案

出现错误是因为{[Index]-1}之前没有任何内容是列表值，但您希望使用以下语法索引到表的行中: c1>

The error comes because {[Index]-1} without anything before it is a list value, but instead you want to index into a row of a table with this syntax: MyTable{index}

看起来像:

= Table.AddColumn(#"Added index", "custom column", each #"Added index"{[Index]-1}[My Column])

这篇关于如何从Power Query的上一行中获取列值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！