using LEFT ..............
in Power BI / Text Functions
will Power BI automatically stop fetching chars when there is a space?!! for example:
in Excel will return
2 answers ( 0 marked as helpful)
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.
Hi sorry I asked the wrong question
I just noticed the formula in the lecture:
I thought it was: