REPT DAX Function in Power BI
The REPT DAX function repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
DAX Syntax REPT(Text, NumberOfTimes)
The function has the following parameters:
• Text: It specifies the text that we want to repeat.
• NumberOfTimes: A positive number specifying the number of times to repeat text.
Example: Let’s create a measure with name “REPT Measure”.
DAX
REPT Measure = REPT("Ashish", 2)
The output of the above dax code is shown below:
