tazeo
Board Regular
- Joined
- Feb 15, 2007
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
I often find myself sifting through large amounts of data to identify relevant keywords, and as many of you may know, this can be a time-consuming and sometimes frustrating process, particularly when it comes to spelling errors.
To address this issue, I came up with the idea of using PowerBI to streamline the process. My plan was to set up a report or dashboard that would display the imported or updated data, and then allow me to enter the keywords I am searching for. The idea is that it would return any rows that contain any of the specified keywords.
However, I've encountered a problem. The searches or slicers I create in PowerBI are only providing AND results, which means it only displays rows that contain all the keywords entered. This is often problematic as it frequently returns nil results.
While I have come across some information on Google that suggests this is possible, I haven't been able to find any instructions that work. Although I found a solution using PowerQuery, I haven't tried it because I want to share this approach with my colleagues, and we frequently need to search for different keywords.
Therefore, I'm looking for suggestions on how to achieve the desired OR results. If anyone has any ideas or alternative solutions (besides PowerBI), I would be grateful for your insights
To address this issue, I came up with the idea of using PowerBI to streamline the process. My plan was to set up a report or dashboard that would display the imported or updated data, and then allow me to enter the keywords I am searching for. The idea is that it would return any rows that contain any of the specified keywords.
However, I've encountered a problem. The searches or slicers I create in PowerBI are only providing AND results, which means it only displays rows that contain all the keywords entered. This is often problematic as it frequently returns nil results.
While I have come across some information on Google that suggests this is possible, I haven't been able to find any instructions that work. Although I found a solution using PowerQuery, I haven't tried it because I want to share this approach with my colleagues, and we frequently need to search for different keywords.
Therefore, I'm looking for suggestions on how to achieve the desired OR results. If anyone has any ideas or alternative solutions (besides PowerBI), I would be grateful for your insights