I need to build this in my PQ but with an amount limit being applied. Example - once the total reaches $168,600 (US SS wage limit). Could you advise? Thank you.
@PowerMquery
8 күн бұрын
You means when the accumulated values reach 168,600, it should be restart from 0?
@finzblazin
8 күн бұрын
@@PowerMquery - Not restart but just stop accumulating past the limit amount
@abdelazizallam
8 күн бұрын
thanks i try the same let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type datetime}, {"Column2", Int64.Type}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "date"}, {"Column2", "amont"}}), x = Table.AddIndexColumn(#"Renamed Columns", "Index", 1, 1, Int64.Type), #"Added Custom" = Table.AddColumn(x, "Custom", each List.Sum( List.FirstN( x[amont],[Index]))) in #"Added Custom"
Пікірлер: 13