I have an XML field in my table that is something like that:
I Know the lcid that I want,
How can I keep only a specific text in dax query and not all xml text?
Go to Solution.
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.
View solution in original post
@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
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!