Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

I need to Extract first 3 character ?

Hi All   Can some one share with me how to do the above mentioned ?  
Need Help
  • lukiz84's avatar
    lukiz84
    4 years ago

    Power BI / DAX: Add a calculated column with the Code:

     

    CalculatedColumn := LEFT([Customer/Vendor], 3)

     

    PowerQuery:

     

    nextStep = Table.AddColumn(previousStep, "newColumn", each Text.Start([#"Customer/Vendor"], 3), type text)
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    In the Query Editor, you may also try the "Column from Example" feature.

lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
4 years ago

Power BI / DAX: Add a calculated column with the Code:

 

CalculatedColumn := LEFT([Customer/Vendor], 3)

 

PowerQuery:

 

nextStep = Table.AddColumn(previousStep, "newColumn", each Text.Start([#"Customer/Vendor"], 3), type text)