Forum Discussion

nomanches's avatar
nomanches
New Member
2 years ago
Solved

Extract value matching criteria from comma separated string/values

Hello,    I hope I can get some help on this, my apologies if this is listed incorrectly as its my first post.    I recently started using PowerBi and what a tool it is, I have been able to look ...
Need Help
  • rsbin's avatar
    rsbin
    2 years ago

    Good Morning nomanches ,

    Appears you have blank records in your raw data set.

    Best to remove those prior to import so you have a "clean" dataset.  If you are unable, then I added a first step in the Power Query to filter out those records where Assigned Advisors is null or blank.

    Please see attached.

    Best Regards,

rsbin's avatar
rsbin
Community Champion
2 years ago

nomanches ,

Here is a 3rd Version for you to review.

Realized that I filtered out records that did not contain (Advisor).

I believe this version works if you need to retain all records including where Advisor = blank.

Regards,

nomanches's avatar
nomanches
New Member
2 years ago

rsbin 

 

Thanks for catching that, I did need to identify those that are not assigned and this helps do that. Although I was able to follow the steps you provided, I am getting an error and it appears to happen at the Find Advisor (Custom Column), this is what it looks like in the data set.

 

I noticed the red/error notification on the columns appeared after this step and when I click on the error link it displays the following:

 

When I go to close and apply the changes I am getting the following error message:

Thanks once again for taking the time look at my issue. 

  • rsbin's avatar
    rsbin
    Community Champion
    2 years ago

    Good Morning nomanches ,

    Appears you have blank records in your raw data set.

    Best to remove those prior to import so you have a "clean" dataset.  If you are unable, then I added a first step in the Power Query to filter out those records where Assigned Advisors is null or blank.

    Please see attached.

    Best Regards,

    • nomanches's avatar
      nomanches
      New Member
      2 years ago

      Good Morning rsbin , 

       

      Thank you for taking the time to assit me, I followed your recommendations and was able to get the list of advisors extracted and retained the blank cells as well. Thanks to you I have a file I can now work with. 

       

      Have a great day!