Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a list of part numbers where i want to filter anything out that is not in a particular format.
The format I want to keep is:
XX-#####-X-###
Where x = any letter of the alphabet
and # = any number
The sort of thing i want to filter out is:
SKF 618/7
166933
HK0808
etc
Do you think this is possible?
Thanks
Chris
Solved! Go to Solution.
I think I have solved it - The following seems to work well
= if(mid(Table[Column],11,1)="-"&& mid(Table[Column],9,1)="-"&& mid(Table[Column],3,1)="-",TRUE,FALSE)
Thanks for your help
Chris
Hi @chydewf1,
Please create a column to get ture if text column CONTAINS specified value "-" using search and text.contains in this thread.
I test it using the sample table and create a calculated column through search function.
sign = IF ( IFERROR ( SEARCH ( "-", Test[Value] ), -1 ) > 0, TRUE (), FALSE () )
Then you can use the [sign] column to create a new table, slicer or other filters(page/report level filter) to filter your table rows.
Thanks,
Angelia
Thanks for your reply.
It almost works but does not filter this sort of thing:
0.8X-V175
Ideally I would say if the 3rd, 9th and 11th characters are "-" then return TRUE
Is there any way I can achieve this?
Thanks
Chris
I think I have solved it - The following seems to work well
= if(mid(Table[Column],11,1)="-"&& mid(Table[Column],9,1)="-"&& mid(Table[Column],3,1)="-",TRUE,FALSE)
Thanks for your help
Chris
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |