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

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!