Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi,
Is there any options to remove items from a list which starts with underscore.
_1,_2,_3 should be removed. It can have any number of items starting with underscore
List
A
B
_1
_2
_3
Tried List.removematchingitems that remove only exact match.
Thank you
Solved! Go to Solution.
= List.Select(YourList, each not Text.StartsWith(_,"_"))
Thank you. It works.
= List.Select(YourList, each not Text.StartsWith(_,"_"))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
31 | |
28 | |
19 | |
15 | |
12 |
User | Count |
---|---|
20 | |
18 | |
13 | |
10 | |
10 |