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 ...
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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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.

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      Are you working in Edit query mode? In that, you need to use the M language. Left is Dax function.

      In Model view (Not in edit query mode), create a new column, it should work

       

      Edited - Seems like got the solutions .