List.Buffer is a Power Query M function that stores a given list in memory, creating a stable list. The function returns a buffered version of the input list.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
List.Buffer( list as list ) as listDescription
Buffers the list list in memory. The result of this call is a stable list.
Examples
Create a stable copy of the list {1..10}.
// Output: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
List.Buffer( {1..10} )Related articles
Learn more about List.Buffer in the following articles:
- Create Running Totals in Power Query M (Ultimate Guide)
Learn how to easily create a running total in Power Query. Tried other approaches that are slow? These tricks will get you your cumulative values FAST! » Read more - Replace Values in Power Query M (Ultimate Guide)
Learn how to replace values in Power Query. Look into conditional replacements, replacing in multiple columns, case sensitivity and more! » Read more
Related functions
Other functions related to List.Buffer are:
