Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Considering they are number columns, you may also try the following:
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
Give this a try.
questionnr =
RIGHT (
Questionanswer[questionAnswersId],
LEN ( Questionanswer[questionAnswersId] ) - LEN ( Questionanswer[AnswerID] )
)
@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
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |