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.
Been playing with the FIND and SEARCH functions and believe there is an issue with FIND. Was wondering if anyone else could confirm before I submit an issue or bug report. Essentially, wildcards do not seem to work at all with FIND despite the documentation that they do.
https://msdn.microsoft.com/en-us/library/ee634882.aspx
They work fine with SEARCH.
Hi @Greg_Deckler,
I can also reproduce the same issue with the latest version(2.54.4970.761 64-bit (January 2018)) of Power BI Desktop.
Column = FIND("?SA",'Country Population'[Country Name],,-1)
Column 2 = SEARCH("?SA",'Country Population'[Country Name],,-1)
Regards
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |