Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
The text you want to repeat.
A positive number specifying the number of times to repeat text.
A string containing the changes.
If NumberOfTimes is 0 (zero), REPT returns an empty string.
If NumberOfTimes is not an integer, it is rounded to the closest integer.
The result of the REPT function cannot be longer than 32,767 characters, or REPT returns an error.
Learn more about REPT in the following articles:
Handling customers with the same name in Power BI
This article explains how to show different customers with the same name in a Power BI report by using zero-width spaces, thus simplifying the presentation without adding visible characters to make the names unique. » Read more
Sorting duplicated names in a level of a hierarchy with DAX
This article describes how to use DAX calculated columns to sort names that look like duplicates at a certain level of a hierarchy, but are unique when considering their full path within the hierarchy. » Read more
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/rept-function-dax