Extract text inside quotes

In Power Query, you can go to Transform > Extract > Text Between Delimiters. 
If you need to do it in DAX, then try:

Text Between Quotes = 
var startIndex = SEARCH(">", [columnName]) // find the index of the first > character
var remainingText = LEFT([columnName], LEN([columnName]) - startIndex)
var endIndex = SEARCH("<", [columnName]) // find the index of the next quote character (starting from the startIndex)
return LEFT(remainingText, endIndex)

(I haven't tested the code, so you will need to do some tweaking. Hopefully you get the idea)