DAX Text - REPT function


Advertisements

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.
dax_functions_text.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements