I know what I am trying to achieve but not really sure how to really begin to solve involves the following:
- I have a Data query that has lots of rows, but one column specifically is the “License Type”.
- The license types themselves are referenced in separate “Bundle” queries that contain the Bundle name and the license types.
In my PBIX file, I have included the sample queries and the desired final table. But I’ll explain what I am looking for here. In my final table, I am wanting to cross reference the Data query with the Bundle query and produce a column that shows all the License Types that were used in the Data query.
I’m having trouble figuring out where to begin because I know that there will be some License Types that are included in the bundle, but since they weren’t actually used, I want to omit them from the final “License Actually Used” column in my example table.
License-Bundle.pbix (31.7 KB)
I hope I explained that correctly. Any help would be much appreciated.