如何从Power Query的上一行中获取列值? [英] How can I get a column value from previous row in 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])
这篇关于如何从Power Query的上一行中获取列值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文