Forum Discussion
Count of Multiple selection data in one row
Hi all, I have a question about visualizing the multiple choices here. For example, if i have a data like this in the SharePoint List: When i visualize it using the intergate Power ...
Hi, Anonymous
Accoding to your description, you should use this method to connect to sharepoint list data. I create a sample in my sharepoint list to operate.
And then you can expand the product name in Power Query.
Like this:
Then you will get all rows.
Finally you can count the name in desktop.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.If not, please feel free to ask me.Best Regards,Community Support Team _ Janey
v-janeyg-msft
Community Support
Community SupportHi, Anonymous
Accoding to your description, you should use this method to connect to sharepoint list data. I create a sample in my sharepoint list to operate.
And then you can expand the product name in Power Query.
Like this:
Then you will get all rows.
Finally you can count the name in desktop.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey