Last answered:

13 May 2022

Posted on:

13 May 2022

0

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

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

2 answers ( 0 marked as helpful)
Instructor
Posted on:

13 May 2022

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.

Posted on:

13 May 2022

0

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

Submit an answer