Text.Repeat

This function generates a new text value by repeating the original input text a specified number of times.

Syntax

Text.Repeat(text as nullable text, count as number) as nullable text

About

This function generates a new text value by repeating the original input text a specified number of times.

Explanation

Example 1 Input: "a" is instructed to be repeated five times by using Power Query M function Text.Repeat("a", 5) Output: "aaaaa" Example 2 Input: "helloworld." is instructed to be repeated three times using Power Query M function Text.Repeat("helloworld.", 3) Output: "helloworld.helloworld.helloworld."