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.
I have a fairly convoluted problem that I could solve in a few minutes with Javascript but seem to be unable to solve with DAX or PowerBI. Heres my setup;
I have several tables, but of most importance to this problem, is a Search Term Data table and a Keyword Data table. These tables are both connected to a Campaigns table via a many to one relationship on a Campaign ID related connection.
I am trying to determine, for each entry in Search Term Data, if a Search Term already appears as a Keyword in the Keyword Data table. Complicating this challenge is the need for both Search Term Data and Keyword Data tables be filtered in scope to a specific Campaign ID for this query. If the value does already exist returning TRUE or "Yes" is an ideal goal.
I believe for this to work as intended, I need to create a new column so that each row of Search Term Data has its own result. When I searched around, most of the similar questions here did not work or account for this specific use case with both tables needing to be filtered first.
Hi @Anonymous
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. if not, please share more details about your question, we'd like to provide further support. thanks!
A lot going on, so i'm not sure if I understood the scenario.
A few months ago I created a search keyword across multiple fields & table by playing around with the model.
Have you thought about merging Table.[Search Term Data] with Table.[Keyword Data] in the edit queries?
If you do that you can have both columns next to each other and easily do anything you want.
The end result can look like this:
(I merged Keyword into Search Term) I would send you this pbix if I could, but there isn't an option for that.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |