DAX Text - REPT function

---

Description

Repeats text a given number of times.

Syntax

REPT (<text>, <num_times>) 

Parameters

Sr.No.	Parameter & Description
1	text The text you want to repeat.
2	num_times A positive number specifying the number of times to repeat the text.

Return Value

A text string.

Remarks

You can use DAX REPT function to fill a cell with a number of instances of a text string.

• If number_times is 0 (zero), DAX REPT function returns a blank.

• If number_times is not an integer, it is rounded.

• If the result of the DAX REPT function is longer than 32,767 characters, an error is returned.

• If you are using a text parameter directly, enclose it in double quotes.

Example

= REPT ("55",2) returns 5555. 
= REPT (55,2) returns 5555. 
= REPT("AB",5) returns ABABABABAB. 
= REPT("AB",2.2) returns ABAB. 
= REPT("AB",2.5) returns ABABAB. 
= REPT("AB",0) returns Blank.