How do remove a specific number of digits based on the number of digits in a different column

[ThomasWeppler]

I have two colums one with a nr. of the question form and one with the questionform and questionnumber right after in the same colum, but I only need question nr.

Is their a good measure I can us for that.
I tried 

questionnr = RIGHT(Questionanswer[questionAnswersId],3), but if answerid or questionnr get more digits it starts to add new problems.

[vivran22]

@ThomasWeppler 

Considering they are number columns, you may also try the following:

Extract Num =

VAR _Sub = 'Test Table'[Col1] * 10^(LEN('Test Table'[Col2]) - LEN('Test Table'[Col1]))

VAR _Diff = 'Test Table'[Col2] - _Sub

RETURN

_Diff

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)


https://www.vivran.in/

Connect on LinkedIn

[jdbuchanan71]

@ThomasWeppler 

Give this a try.

questionnr =
RIGHT (
    Questionanswer[questionAnswersId],
    LEN ( Questionanswer[questionAnswersId] ) - LEN ( Questionanswer[AnswerID] )
)

[smpa01 · Accepted solution]

@ThomasWeppler  you can do this, pbix is atatched

Column = 
VAR _leftLength = LEN(VALUE('Table'[Column1]))
VAR _rightLength = LEN(VALUE('Table'[Column2]))
VAR _lenthToExtract = _leftLength-_rightLength
VAR _value = MID(VALUE('Table'[Column2]),_leftLength+1,_rightLength)
RETURN _value