REPT Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.


REPT(text, num_times)


text – The text you want to repeat.
num_times – A positive number specifying the number of times to repeat text.

Return Value

A string containing the changes.

Reference Data

DAX Functions / Text Functions / REPT