Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm working with a table that, in one column, contains different strings of text that I need to extract data from. Some of these strings include:
NOTE: The bold underlined number is what I need.
Basically, if a number is proceeded by "onfidence: " and followed by "%" I need to add it to its own column. I found a couple of ways to achieve this, but the result was I could no longer use a live connection with DirectQuery. As my database is beyond massive, import mode is not an option. Also due to circumstances, I am unable to parse in the database before connecting to Power BI.
So, is there a way I can parse the required data from the column while staying in DirectQuery mode (possibly using a DAX query)? Or am I out of luck?
Solved! Go to Solution.
Hi @reno1
Are you able to add calcualted columns to your tables? If so this might be close
Parsed Column = var myStart = FIND("onfidence:",'Table3'[Text],,0) var myLength= FIND("%",Table3[Text],myStart + 11,0) - (myStart + 11) var myResult = IF(myStart>0,MID('Table3'[Text],myStart + 11,myLength),Blank()) RETURN int(myResult)
Hi @reno1
Are you able to add calcualted columns to your tables? If so this might be close
Parsed Column = var myStart = FIND("onfidence:",'Table3'[Text],,0) var myLength= FIND("%",Table3[Text],myStart + 11,0) - (myStart + 11) var myResult = IF(myStart>0,MID('Table3'[Text],myStart + 11,myLength),Blank()) RETURN int(myResult)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |