OpenBI Docs Buy

Text.Repeat

A text written a number of times in a row.

Group: Text and characters. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Text.Repeat(text as nullable text, count as number) as nullable text
ParameterTypeDescription
textnullable textThe text to work on; null gives null.
countnumberHow many times; 0 gives an empty text.

Returns

nullable text. The text repeated.

Examples

A line for a printed list

Text.Repeat("-", 10)
"----------"

Text.PadStart, Text.PadEnd, List.Repeat.

Last updated · OpenBI Studio 0.3.79