Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |