LEFT DAX Function

The LEFT function returns the specified number of characters from the start of a text string.

DAX Syntax LEFT(text, num_chars)

The function has the following parameters: • text: The text string containing the characters we want to extract, or a reference to a column that contains text. • num_chars: The number of characters we want LEFT to extract; if omitted, 1. If the num_chars argument is a number that is larger than the number of characters available, the function returns the maximum characters available and does not raise an error.

Example: Create a calculated column. The following expression returns first three characters from the Country column.

DAX