Forum Discussion

smpa01's avatar
smpa01
Community Champion
8 years ago
Solved

Extracting Data from Column with different Length- Starting Index 0 but Number of Character Variable

Hello guys,

 

I have a set of data in Description column like this. I want extract data in Desired Column with starting index 0 and NUmber of characters as per the value in Required Length column.

 

Can it be done Power Q/PBIX?

 

Thank you in advance.

 

 

 

Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Add new column with following formula:

     

    Desired Description = Left(Table1[Desription], Table1[Required Length])

6 Replies