Forum Discussion
Powerbi
Hi AtchayaP,
Under the assumption you have already loaded the column/table to Power Query, you can go to Transform > Split Column > By Delimiter > Comma (Each occurence of the delimiter):
Next you can select all column headers, right click and select Unpivot Columns. This will put all the items in rows:
Finally, apply these step changes and create a DAX measure in your model to count the number of rows (either COUNTROWS or DISTINCTCOUNT). Hope this helps.
2 Replies
Hi AtchayaP,
Under the assumption you have already loaded the column/table to Power Query, you can go to Transform > Split Column > By Delimiter > Comma (Each occurence of the delimiter):
Next you can select all column headers, right click and select Unpivot Columns. This will put all the items in rows:
Finally, apply these step changes and create a DAX measure in your model to count the number of rows (either COUNTROWS or DISTINCTCOUNT). Hope this helps.
Even simpler, you can expand 'Advanced Options' within the Split Column by Delimiter screenshot and split them to rows, which would skip out the middle step!