Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How would this Excel formula be in Power Bi

I would greatly appreciate your help.
I need to create a table with the first 9 characters of each data in this table.

I already searched but I have not understood how to adapt it to my need
I also tried LEFT (<text>, <num_chars>) and I get an error.
thanks.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    amitchandak 

    try with
    = Text.Start ([UANO], 9) and what I needed came out.
    I appreciate your time taken to help me, greetings.

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    The left should give you the required result. Can you share the error?

     

    like :  LEFT (UANO, 9)

     

    If possible please share a sample pbix file after removing sensitive information.
    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       

       

      This is the error.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        amitchandak 

        try with
        = Text.Start ([UANO], 9) and what I needed came out.
        I appreciate your time taken to help me, greetings.