- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
REMOVE RECORD ON LIST IN POWER EDITOR
Please help me!!!
I have List contain Record like that: {"a", [{a1,a2}, {b1,b2}], "b", [{a1,a2},{d1,d2}], ""}
a |
Record |
b |
Record |
"" |
I want to remove Record on list and return it by text, result:
a
b
How can I do that?
Link file example:
https://drive.google.com/file/d/14Ckb0rFQR0zAnQXQA4ahQvaCQolsFBqg/view?usp=sharing
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @SonLeThai ,
make the Json file available as well, this is required because I'm going to clean the record inside Power Query.
Regards,
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @SonLeThai ,
please create a pbix that contains sample data, upload the pbix to onedrive, Google Drive, or Dropbox, and share the link.
Regards,
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @SonLeThai ,
make the Json file available as well, this is required because I'm going to clean the record inside Power Query.
Regards,
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
tks you!!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
04-01-2024 12:47 PM | |||
06-17-2024 10:07 AM | |||
02-19-2024 11:53 AM | |||
06-06-2023 08:28 AM | |||
01-10-2020 01:57 AM |
User | Count |
---|---|
127 | |
81 | |
59 | |
59 | |
44 |
User | Count |
---|---|
182 | |
119 | |
82 | |
68 | |
53 |