REPT functions is a Power BI text function in DAX which repeats text a given number of times.
is the text that you want to repeat.
is a number which specifying the number of times to repeat text, it must be positive number.
Lets look at an example of using REPT function in Power BI.
Here we have a sample data of customer feedback, you can see customers have given a ratings out of 5.
Now we will see the use of REPT function.
Lets use a REPT function to repeat a text any specified number of times.
Let’s create a new column named RepeatText that uses the REPT function which repeats text Hello up to 5 times.
RepeatText = REPT("Hello", 5)
Rept_Rating = REPT ( UNICHAR ( 128513 ), CustomerFeeback[Ratings] ) & REPT ( UNICHAR ( 128530 ), 5 - CustomerFeeback[Ratings] )
1,097 total views, 2 views today