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 - Exploring Power Query Buffering: How Table.Buffer and List.Buffer Work
The article explains how Power Query’s Table.Buffer and List.Buffer create stable, shallow buffers for tables and lists. It covers their behavior with scalar values, records, and errors, noting that they don’t buffer nested values. » Read more
Related functions
Other functions related to List.Buffer are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy