I need to Extract first 3 character ?

Hi All Can some one share with me how to do the above mentioned ?

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
4 years ago
Hi,

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

Forum Discussion