March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
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
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
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
tks you!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |