How can I remove the first 7 digits of string in POWER BI?

Question

I want to remove the first 7 digits of a Text using DAX. I know that it's possible to use the RIGHT and LEFT function in Excel, so is there something similar in Power BI?

Answer 1

To remove the first 7 digits of the string in POWER BI. You need to go through some process

In the Query Editor, you can use 

Transform->Split Column->By Number of Characters and then use these settings:

Then one file will open SPLIT COLUMN BY NO OF CHARACTER

Then write no of character

You need to choose repeatedly among them, After that, you need to choose between rows and columns

Then fill that box no of columns to split into=(), write any no according to your need...

Code:

 

LEFT(TableName[ColumnName], 7)