Forum Discussion
Solved
XML fields in DAX
I have an XML field in my table that is something like that: <texts> <text lcid="1040">Ciao<text> <text lcid="2057">Hello<text> </texts> I Know the lcid that I want, How can I keep only a sp...
Hi lfrigione,
The field is already a xml type. Then you can parse that field. Finally, you can extract the values you want. Please refer to the snapshot below.
Best Regards,
Dale
lfrigione You can transform your value to xml in the power query editor and parse it out.
I can not find how to format the field as xml type
Hi lfrigione,
The field is already a xml type. Then you can parse that field. Finally, you can extract the values you want. Please refer to the snapshot below.
Best Regards,
Dale