REPT

Syntax

REPT(<text>, <num_times>)  

Tutorial with example

In this video we will go through the DAX function REPT.

Download example file:

Link to pbix file

Another Example with REPT:

Remarks

• If number_times is 0 (zero), REPT returns a blank.
• If number_times is not an integer, it is truncated.
• The result of the REPT function cannot be longer than 32,767 characters, or REPT returns an err