Forum Discussion
lfrigione
Helper II
Helper IIXML 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
lfrigioneHelper II
Helper III can not find how to format the field as xml type
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi 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