如何从Power Query的上一行中获取列值?

本文介绍了如何从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])