Power Query, vorangehende Zeile (Vorgänger)
neue Abfrage erstellen, Language M Code einfügen, Abfrage umbenennen in fxTablePreviousRow --- SCHNIPP --- (MyTable as table, MyColumnName as text) => let Source = MyTable, ShiftedList = {null} & List.RemoveLastN(Table.Column(Source, MyColumnName),1), Custom1 = Table.ToColumns(Source) & {ShiftedList}, Custom2 = Table.FromColumns(Custom1, Table.ColumnNames(Source) & {"PreviousRowColumnValue"}) in Custom2 --- SCHNAPP --- Quelle Imke Feldmann https://www.thebiccountant.com/ https://www.thebiccountant.com/2018/07/12/fast-and-easy-way-to-reference-previous-or-next-rows-in-power-query-or-power-bi/ siehe Beispielmappe (download) Lern Video