Forum Discussion
Split column into multiple rows and equally divide a value grouped by the splitted column
Hi everyone, I would like to split a column with a delimeter into multiple rows and divide the value by the count of rows splitted into. Like in a screenshot I attached , I would like to sp...
Hi,
I was searching for the DAX on your problem when I discovered this past thread, which is highly relevant to yours.
https://community.powerbi.com/t5/Desktop/Count-no-of-comma-occurrences-in-a-column/td-p/79183
multiple ways to do it - eg You can delimit the column, but I would create a copy and find DAX to count the number of times a comma occurs.
Sorry I couldn't give a specific query to your issue!