using LEFT ..............
will Power BI automatically stop fetching chars when there is a space?!! for example:
in Excel will return
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.