using LEFT ..............

Question

Hi Dimitar
will Power BI automatically stop fetching chars when there is a space?!! for example:

Ann Suri
in Excel will return
Ann S

Thanks

Answer 1

Hi, Power BI will recognize the space as a character as well, so it will return the same result Ann S if you wanted to fetch five characters from the left.

Answer 2

Hi sorry I asked the wrong question

I just noticed the formula in the lecture:
LEFT(dim_Customer[FirstName],5)

I thought it was:
LEFT(dim_Customer[CustomerName],5)

Greetings

using LEFT ..............

Submit an answer

related questions